COUNT # ROWS where 2 conditions are true

Solved/Closed
tepatl - Nov 11, 2009 at 10:21 AM
aquarelle Posts 7118 Registration date Saturday April 7, 2007 Status Moderator Last seen July 29, 2022 - Nov 11, 2009 at 04:08 PM
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

aquarelle Posts 7118 Registration date Saturday April 7, 2007 Status Moderator Last seen July 29, 2022 491
Nov 11, 2009 at 04:08 PM
Hi,

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

Best regards
1