Power users need your help – calculation based on a date

G

General X

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,
 
D

Don Guillett

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