COUNT # ROWS where 2 conditions are true

[Solved/Closed]
Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
Hello,
I am having problems counting the # rows of problem reports where the priority = 1 and the PR is active.
here is the array:
PR PRIORITY ACTIVE
1 2 Y
2 1
3 2 Y
4 1
5 1 Y
6 2
7 1 Y


I simply want to show that there are 2 problem reports active that are priority = 1.
I have tried many things, including:
IF($PRIORITY$1:$PRIORITY$7=1,COUNTIF($ACTIVE$1:$ACTIVE$7,"=Y"))

This is simplified but the principle is the same. Please advise

1 reply

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
486
Hi,

Try with this formula (Column A containing PRIORITY, Column B containing ACTIVE) :
=SUMPRODUCT((A1:A7=1)*(B1:B7="Y"))

Best regards
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!