# filtering then calculating

#### bpflyr

##### Board Regular
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!

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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

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: ??

Replies
1
Views
128
Replies
3
Views
265
Replies
3
Views
243
Replies
12
Views
316
Replies
3
Views
443

1,196,318
Messages
6,014,614
Members
441,832
Latest member
tony tessman

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back