SUMPRODUCT with multiple criteria

[Kirbstomp1287]

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]

=SUMIFS(AC:AC,F:F,"February",J:J,"Observed")

 

[Rick Rothstein]

What is in Column F... actual dates (possibly formatted to show the month name) or the month name typed in as text?

 

[Kirbstomp1287]

What is in Column F... actual dates (possibly formatted to show the month name) or the month name typed in as text?

It is formatted as 1/25/2019. So it really should be looking for "2" for February?