Total spending per month

  • Thread starter Thread starter Phillip Parr
  • Start date Start date
P

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
 
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.)
 
cool, thanks :)

Phil

Arvi Laanemets said:
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.)
Click to expand...
 
Back
Top