Excel - Count rows where 2 conditions are true
Issue
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
Solution
Try with this formula (Column A containing PRIORITY, Column B containing ACTIVE):
=SUMPRODUCT((A1:A7=1)*(B1:B7="Y"))
Note that
Thanks to aquarelle for this tip on the forum
Related
- Excel count rows where 2 conditions are true
- COUNT # ROWS where 2 conditions are true ✓ - Forum - Excel
- Excel - Change row color on condition - How-To - Excel
- Excel insert row if condition met - How-To - Excel
- Excel copy row from one sheet to another if a condition is met ✓ - Forum - Office Software
- Excel copy row if condition met ✓ - Forum - Excel
This document, titled « Excel - Count rows where 2 conditions are true », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
0 Comments
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty