gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 351
- Office Version
- 365
- Platform
- Windows
- Mobile
My SUMIF isn't working, and I'm wondering what I need to do, or if an alternative is needed. Basically, I need to total up some profits if they were earned during the current month, whatever that may be. I have a helper column that uses MONTH(B2) where B2 is the Scheduled Date. Then I put the SUMIF in a totals cell, where it uses the entire scheduled date column for criteria 1, the entire helper column for criteria 2, and then a separate profits column for the sum criteria. On evaluation, the criteria range is resolving as a blank.
=SUMIF(MASTER!$E$2:$E$1048576,Internal!AD2:$AD$1048576=MONTH(NOW()),MASTER!$S$2:$S$1048576)
=SUMIF(MASTER!$E$2:$E$1048576,Internal!AD2:$AD$1048576=MONTH(NOW()),MASTER!$S$2:$S$1048576)