COUNT # ROWS where 2 conditions are true
Solved/Closed
tepatl
-
Nov 11, 2009 at 10:21 AM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Nov 11, 2009 at 04:08 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Nov 11, 2009 at 04:08 PM
Related:
- COUNT # ROWS where 2 conditions are true
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Resident evil 2 remake free download - Download - Horror
1 response
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
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