E
Eric
I have dates in column A
Numbers in column B
I want to find the sum of numbers on column B that correspond to the last 30
days (including today), 90 days, 6 months, 1 year.
I used
=SUMIF(A:A,(TODAY()-30),B:B)+SUMIF(A:A,(TODAY()-29),B:B)+SUMIF(A:A,(TODAY()-28),B:B)... etc. until I got 30 days.
Q? Is there an easier formula/method?
Numbers in column B
I want to find the sum of numbers on column B that correspond to the last 30
days (including today), 90 days, 6 months, 1 year.
I used
=SUMIF(A:A,(TODAY()-30),B:B)+SUMIF(A:A,(TODAY()-29),B:B)+SUMIF(A:A,(TODAY()-28),B:B)... etc. until I got 30 days.
Q? Is there an easier formula/method?