Total spending per month

[Phillip Parr]

Hello, I have a spreadsheet full of credit/debit transactions spanning from
01/01/2000 to the present and was wondering how I could calculate the
spending per month, or spending for the past 30 days.

Thanks

 

[Arvi Laanemets]

Hi

=SUMPRODUCT((DateRange>DATE(Y,M,0))*(DateRange<DATE(Y,M+1,1)*(SumRange))

=SUMPRODUCT((DateRange>TODAY()-31)*(SumRange))

(DateRange and SumRange are references to ranges with dates and amounts, or
named ranges. Y and M are year and month numbers, which identify month you
are summing up.)

 

[Phillip Parr]

cool, thanks

Phil

Hi

=SUMPRODUCT((DateRange>DATE(Y,M,0))*(DateRange<DATE(Y,M+1,1)*(SumRange))

=SUMPRODUCT((DateRange>TODAY()-31)*(SumRange))

(DateRange and SumRange are references to ranges with dates and amounts, or
named ranges. Y and M are year and month numbers, which identify month you
are summing up.)