adding cells in a date range from today

[ANTHILL]

Hello everyone.

In a nutshell, I would like to find totals in the previous 90 days.

Sheet 2;
I have column A with a list of dates
Column B with a list of numbers

Sheet 1;
I would like it to reference Sheet 2
I would like it to find todays date in sheet 2, column A
I would like it to count back 90 days from todays date
I would like to find the total in column B in the last 90 days from todays date.

Maybe I could have explained this better?!

Any assistance would be greatly appreciated.

Regards

Ant Hill

 

[steve the fish]

Depends on whether today -90 is inclusive or exclusive but something like:

=SUMIFS(B:B,A:A,">"&TODAY()-90)

 

[ANTHILL]

Depends on whether today -90 is inclusive or exclusive but something like:

=SUMIFS(B:B,A:A,">"&TODAY()-90)

Steve the fish, many thanks for your quick and perfect answer.
I really appreciate it. This has solved the question.
Regards.
Ant