filtering then calculating

[bpflyr]

I am trying to develop a logbook. There will be about 20 columns and unlimited rows. On a separate summary page I would like to break some of the numbers down.

Let's say in Flight Time. How can I get Excel to look backwards from today's date 90, 180 days, 6 months, etc, and calculate the total for the specified time.

I also need this figure to be transfered from the main worksheet to the Summary worksheet. How do I do all of this?

Can you also tell me how to make Excel total the columns for an infinite number of rows?

Thank you so much!

 

[plettieri]

Hi and welcome to the board

You might have to give us more of an example on your request...

To total a column ie column g...=sum(g:g)

plettieri

 

[bpflyr]

O.K. Let's say I have 60 entries for Flight Time (ex. 1.5, 2.2, 3.6, etc) for the year all in column C.
I would like to be able to filter these entries for the preceeding 90 days. What I ultimately need is the total for the Flight Time for the preceeding 90 days.
The table will look something like this:

Date Aircraft Flight Time
01-10-05 N12345 1.5
07-06-05 N12356 2.2

Flight Time Total: 3.7
Flight Time Preceeding 90 days: ??