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.
--------------------
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.