IF Function Help

[SimeC]

Hi
I discovered this forum and hope some of you guys can help as I a
somewhat of a newbie with excel. I am using the IF function to put
value in a cell if the dates in 2 sheets are the same. What I want t
know is that is there a way of making the value remain in the cell onc
the date has changed. I need it to add up weekly amounts. Cheers

 

[Bob Phillips]

It is bound to be possible in one form or another, probably with VBA.

Explain exactly what you want to do in more detail.

 

[Sandy Mann]

Hi SimeC

If you mean that you want the value to appear in the cell at and after a
certain date the try:

=IF(A9<=TODAY(),SUM(B2:B8),"")

HTH

Sandy