Thanks for the info Ken, I'm sure it will come in handy some day, but I don't
think it would work in this situation, because my data has too many open
cells, if I don't have a particular type of time I leave the cell empty. It
looked like all the cells needed to be filled in for the pivot table to work.

"Ken Wright" wrote:

Have you considered using a Pivot table? Assuming your data is in a database
style format, then by adding another field to it that quesries the date for that
record and based on whether it is within the last 90 days or so you will be able
to filter on that alone and yet use all the power that pivot Analysis gives you.
Assuming your data has dates in Col A, then create another field and start with
=A2=(TODAY()-90) and copy down. This will give you TRUE for all records that
are within the last 90 days and this can be used as a filter in the Pivot table.

Some introductory links for Pivot tables

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Frank Kabel" wrote in message
...
Hi
maybe something like
=SUMIF(A1:A1000,"=" & TODAY()-90,B1:B1000)

--
Regards
Frank Kabel
Frankfurt, Germany


TylerMaricich wrote:
I'm a pilot trying to use excel 2002 to calculate my logbook, and
need to know how much of the time was in the last 90 days, I'm
looking for a formula that will help me sort, and add the data from
just the last 90 days.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004