IF Function Help

  • Thread starter Thread starter SimeC
  • Start date Start date
S

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
 
It is bound to be possible in one form or another, probably with VBA.

Explain exactly what you want to do in more detail.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If function across sheets prints value of cell 4
Excel VBA 1
want to track time while paste value in multiple column of same roe 1
countifs Function not giving desired result with date criteria 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
IF function possible? 4
Function or If statement help 1
Function to Return a Date Value Q 4

Back
Top