Hello All,

I have a sheet that has about 1200 rows. Each row has multiple columns. Date (MMDDYY), Total value, description.

On another page I want to figure out how to add the total values if the dates fall into certain ranges.

-Three Months or less
-Over three months through 12 months
-Over one year through 3 years
etc

it needs to reference the report date say cell A1. and calculate the ranges that way.

so if the dates are Over one year through 3 years from today add up the totals.

is what I'm asking even possible?


Thank you all very much.