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?

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?

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

=SUMIF(D:D, =E2, B:B)
D: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)

"Sandy Mann" wrote:

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?

Try this, then:

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

Hope this helps.

Pete

KiowaPilot wrote:
ON MY FILE THAT I WAS WORKING ON,
i WAS TOYING WITH

=SUMIF(D:D, =E2, B:B)
D: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)

"Sandy Mann" wrote:

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?