Try:
Day:
=SUMPRODUCT(($A$2:$A$100=TODAY()-90)*(B2:B100))
Night:
=SUMPRODUCT(($A$2:$A$100=TODAY()-90)*(C2:C100))
NVG:
=SUMPRODUCT(($A$2:$A$100=TODAY()-90)*(D2:D100))
Adjust the range to suit. The absolute ranges ($A$2:$A$100) are so that I
could copy the Day formula across the other two columns.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"KiowaPilot" wrote in message
...
I am trying to keep a log of Flight time and would always like to know what
I've flown within the last 90 days of the current date in several
different
modes of flight.
A B C D
1 Date day night NVG
2 2 Sep 06 1.5 2.4
3 15 Sep 06 1.2 2.6
4 22 Sep 06 2.0 4.0
What is the formula to automatically calculate?