Power users need your help €“ calculation based on a date
 

Power users need your help €“ with a calculation that is based on a date
function and remains a value after the date passes.

The logic: Add several cells, There are 8 rows in the totals column
The column is then summed at the bottom.

The objective is for the column of numbers to sum when the date equals a
spacific date or at the end of the month. The challenge is when the calendar
date changes the total from the previous day does not change. Or is there
a formula that will only sum once on a specific date and the total then
becomes a value so it does not change when the date changes?

This is as far as I got;
=IF(Y7=DATEVALUE("9/30/2005"),(SUM(Y12:Y31)/COUNT(Y12:Y31)),0)

Grateful for any assistance.
best regards,

Power users need your help - calculation based on a date
 

IF?? your layout has dates in one column and numbers in the next
=sumproduct((a2:a200datetostartinacell)*(a2:a200< datetostopinacell)*b2:b200)

--
Don Guillett
SalesAid Software

"General X" <General wrote in message
...
Power users need your help - with a calculation that is based on a date
function and remains a value after the date passes.

The logic: Add several cells, There are 8 rows in the totals column
The column is then summed at the bottom.

The objective is for the column of numbers to sum when the date equals a
spacific date or at the end of the month. The challenge is when the
calendar
date changes the total from the previous day does not change. Or is
there
a formula that will only sum once on a specific date and the total then
becomes a value so it does not change when the date changes?

This is as far as I got;
=IF(Y7=DATEVALUE("9/30/2005"),(SUM(Y12:Y31)/COUNT(Y12:Y31)),0)

Grateful for any assistance.
best regards,