megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 140
- Office Version
- 365
- Platform
- Windows
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:
<tbody>
</tbody>
And like this:
<tbody>
</tbody>
No go both ways.
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.