SUMPRODUCTS 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 (Formatted: 2/25/2019) 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!

[Pete_UK]

Try this:

=SUMPRODUCT((MONTH(F2:F100)=2)*(J2:J100="Observed"),AC2:AC100)

Adjust the ranges to suit, but it is better not to use full-column references with SUMPRODUCT.

Hope this helps.

Pete

[KOKOSEK]

@Kirbstomp1287
Please do not forget to check Forum rules.
Point 3. Cross-post

Cross-post here: https://www.mrexcel.com/board/thread.../#post-5376233

[Kirbstomp1287]

Sick! It worked! I think I just had the order misplaced with mine. Thanks!