Saving time-dependent results

R

RaV

Code:
--------------------
Date Vehicles
February 1, 2006 £119.85
February 2, 2006
February 3, 2006
February 4, 2006
February 5, 2006
February 6, 2006
February 7, 2006

--------------------


The cell with £119.85 is B5 and the formula is
=IF(A5='Daily Sale'!$A$5,SUMIF('Daily Sale'!$D:$D,"Vehicles",'Daily
Sale'!$H:$H),"")

However, I don't know how to save these values when its the next day,
as false values are replaced with null values. How could I make it save
the current date's results, and keep them for the next day?

Thanks for any suggestions.
 

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

Top