COUNTIFS with multiple criteria and with OR condition

1
votes

I'm trying to count the cells based on some criteria as shown in the image but it's returning 0 value.

Formula: =COUNTIFS(All_PRs!R:R,S189,All_PRs!I:I,"2",All_PRs!J:J,{"O","IC"})

enter image description here

1
excelexcel-formula
Wrap it in SUMPRODUCT() – Scott Craner
Just SUM will do - no need for SP. – Rory
Does this answer your question? Using OR & AND in COUNTIFS – Slai

1 Answers

1
votes

It's returning a range, just SUM() it and you should be good.

=SUM(COUNTIFS(All_PRs!R:R,S189,All_PRs!I:I,"2",All_PRs!J:J,{"O","IC"}))