Kirbstomp1287
New Member
- Joined
- Nov 22, 2019
- Messages
- 6
- Office Version
- 2016
- Platform
- Windows
So I am trying to get a total sum of the numbers from column AC, however I need it to only find the Sum if the Month February is in column F and if the text "Observed" is in column J.
Essentially it needs to look for the Month from Column F, Then look for the "Observed" text from Column J, then give me the total sum all numbers in column AC meeting those two criteria.
I have tried a couple different SUMPRODUCT equations and SUMIFS but still haven't gotten it to work properly.
Any help would be much appreciated!
Essentially it needs to look for the Month from Column F, Then look for the "Observed" text from Column J, then give me the total sum all numbers in column AC meeting those two criteria.
I have tried a couple different SUMPRODUCT equations and SUMIFS but still haven't gotten it to work properly.
Any help would be much appreciated!