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!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

KOKOSEK

Board Regular
Joined
Apr 8, 2019
Messages
206
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,665
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,090,334
Messages
5,413,847
Members
403,504
Latest member
rosebo

This Week's Hot Topics

Top