COUNT # ROWS where 2 conditions are true
Solved/Closed
tepatl
-
Nov 11, 2009 at 10:21 AM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Nov 11, 2009 at 04:08 PM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen July 18, 2025 - Nov 11, 2009 at 04:08 PM
Related:
- COUNT # ROWS where 2 conditions are true
- 텐타클 락커 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Saints row 2 cheats - Guide
- Fnia 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
July 18, 2025
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