COUNT # ROWS where 2 conditions are true
Solved/Closed
tepatl
-
Nov 11, 2009 at 10:21 AM
aquarelle Posts 5952 Registration date Saturday April 7, 2007 Status Moderator Last seen February 5, 2026 - Nov 11, 2009 at 04:08 PM
aquarelle Posts 5952 Registration date Saturday April 7, 2007 Status Moderator Last seen February 5, 2026 - Nov 11, 2009 at 04:08 PM
Related:
- COUNT # ROWS where 2 conditions are true
- 텐타클 락커 2 - Download - Adult games
- Saints row 2 cheats - Guide
- My cute roommate 2 - Download - Adult games
- Excel count occurrences - Guide
- Count names in excel - Guide
1 response
aquarelle
Posts
5952
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
February 5, 2026
491
Nov 11, 2009 at 04:08 PM
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
Try with this formula (Column A containing PRIORITY, Column B containing ACTIVE) :
=SUMPRODUCT((A1:A7=1)*(B1:B7="Y"))
Best regards