Thanks Tom, but I still have a problem, I need a fixed amount of data to be
calculated on a given date. i.e., =SUM(A2+B2) ON 05/04/05, =SUM(A2+B2+C2) ON
05/05/05 and so on... I also need to have a similar formula that calculates a
fixed amt of data daily and finds a percentage of two sums. I have tried to
use OnTime and this doesn't seem to allow for the formula growing each day. I
want sales staff to use this spdsheet and not have to do more than key in
sales figures (which will be added by the formula).

"Tom Ogilvy" wrote:

Use formulas that accomplish the detailed requirements you have conveyed.

Formulas update on each calculation.

formulas Like Sum, will not be affected if you specify blank cells in their
range and when you enter data in those cells, they will be included in the
calculation.

Another approach would be to use Pivot Tables with the source data set to a
dynamic range using a defined name

Insert= Name= Define

Name: Table1
Refersto =Offset(Sheet1!$A$1,0,0,countA(Sheet1!$A:$A),10)

as an example

Then use the defined name (range) Table1 as the source for the pivot table.

--
Regards,
Tom Ogilvy


"hw" wrote in message
...
I have a spreadsheet that needs to calculate sales figures for the store &
sales associates both monthly and weekly. I need Excel to recalculate each
day of the month on its own (new info will be keyed in each day). I also
need
it to ignore cells untill they are ready to be used. Please help...