SUMPRODUCT with multiple criteria

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!
 

KOKOSEK

Board Regular
Joined
Apr 8, 2019
Messages
158
Office Version
365, 2013
Platform
Windows
Code:
=SUMIFS(AC:AC,F:F,"February",J:J,"Observed")
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,394
Office Version
2010
Platform
Windows
What is in Column F... actual dates (possibly formatted to show the month name) or the month name typed in as text?
 

Forum statistics

Threads
1,077,649
Messages
5,335,489
Members
399,019
Latest member
prab1101

Some videos you may like

This Week's Hot Topics

Top