assistance using =SumProduct with a date range criteria

[Val_Gal]

Hey Guys!

I'm currently using Sum Product to add up items on a table with a few criteria.
For now it is summing '<=Today()'

=SUMPRODUCT(--(TRANSACTIONS_ALL[date]<=TODAY()),--(TRANSACTIONS_ALL[TYPE]="PENDING CHECK"),TRANSACTIONS_ALL[AMOUT DUE])

Please assist so that instead of '<=Today()', it is searching the same column for the date range of 'this month'.

 

[mart37]

(month(TRANSACTIONS_ALL[date])=month(TODAY()))

 

[FormR]

Please assist so that instead of '<=Today()', it is searching the same column for the date range of 'this month'.

Hi, here is a SUMIFS() alternative which also takes into account the current year.

=SUMIFS(TRANSACTIONS_ALL[AMOUNT DUE],TRANSACTIONS_ALL[Date],">="&EOMONTH(TODAY(),-1)+1,TRANSACTIONS_ALL[Date],"<"&EOMONTH(TODAY(),0)+1,TRANSACTIONS_ALL[TYPE],"PENDING CHECK")