COUNT # ROWS where 2 conditions are true
Solved/Closed
tepatl
-
Nov 11, 2009 at 10:21 AM
aquarelle Posts 5961 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - Nov 11, 2009 at 04:08 PM
aquarelle Posts 5961 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - Nov 11, 2009 at 04:08 PM
Related:
- COUNT # ROWS where 2 conditions are true
- Tentacle locker 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Saints row 2 cheats - Guide
- Excel count occurrences - Guide
- Count names in excel - Guide
1 response
aquarelle
Posts
5961
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
February 14, 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