SUMIF criteria as formula?

[megera716]

I have a table of invoices. Within that table, I have a column with formula [Date]-DAY([Date])+1 to return a m/d/yyyy date that is the 1st day of the invoice month. Off to the side, I SUMIF if the value in that column equals the date in column R, but I was hoping to run this formula within the SUMIF to eliminate that extra column in the table, but I can't get it to work.

I've tried it like this:

Column R	Column S
Date	Amount
10/1/2019	=SUMIF(Table6[Date]-DAY(Table6[Date])+1),R2,Table6[Amount])
11/1/2019	=SUMIF(Table6[Date]-DAY(Table6[Date])+1),R3,Table6[Amount])

<tbody>
</tbody>

And like this:

Column R	Column S
Date	Amount
10/1/2019	=SUMIF(Table6[Date],(Table6[Date]-DAY(Table6[Date]))+1)=R2,Table6[Amount])
11/1/2019	=SUMIF(Table6[Date],(Table6[Date]-DAY(Table6[Date])+1))=R3,Table6[Amount])

<tbody>
</tbody>

No go both ways.

 

[megera716]

Ultimately, I just want to sum the invoice amounts if the invoice date is in the same month as the date in Column R so I'm also open to other approaches for accomplishing that. I realize I could do this with a Pivot but I don't want to because reasons .

 

[Fluff]

How about
=SUMIFS(Table6[Amount],Table6[Date],">="&R2,Table6[Date],"<"&EDATE(R2,1))

 

[megera716]

Eureka, it worked! Thank you so much!

 

[Fluff]

Glad to help & thanks for the feedback