formula to recalculate when new data added

February 9, 2011 at 14:54:34
Specs: Windows XP
I have a formula that takes column a and subtracts column b information. The columns represent daily sales numbers. Now comes day 3 and it's updated but the formula needs to recalculate based on this update. Is there a formula to automatically update the calculation based on new information in a column?

See More: formula to recalculate when new data added

Report •

#1
February 9, 2011 at 15:50:06
Now comes day 3 and it's updated but the formula needs to recalculate based on this update.

What is It's?

If you have:

     A     B     C
1)  $10   $5    $5

With the formula =SUM(A1-B1)
in cell C1,

Any changes in A1 or B1 will automatically be recalculated in cell C1,
unless you have turned off the Auto Calc functions.

Or perhaps, because you have imported your data and Excel interpreted the data as Text not Numbers.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question