sliding calculation

[Guest]

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?

 

[Sandy Mann]

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)*(D2100))

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

ON MY FILE THAT I WAS WORKING ON,
i WAS TOYING WITH

=SUMIF(D, >=E2, B:B)
D BEING THE DATE IN NUMBER FORMAT IN A HIDDEN COLUMN
E2 BEING TODAY()-180 IN NUMBER FORMAT
B:B THE FLIGHT TIME ENTERED

THE PROBLEM WITH THIS THOUGH IS THAT THE CRITERIA WILL NOT ALLOW A FIELD
ADDRESS E2 IN CONJUCTION WITH >= BUT IT WILL ALLOW THEM TO STAND ALONE. IT
WORKS PERFECT IF I TYPE IN

=38800

38800 IS (20 SEPT 2006)

 

[Pete_UK]

Try this, then:

=SUMIF(D, ">="&E2, B:B)

Hope this helps.

Pete