COUNT # ROWS where 2 conditions are true
Solved/Closed
tepatl
-
Nov 11, 2009 at 10:21 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Nov 11, 2009 at 04:08 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 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
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- Red dead redemption 2 free download - Download - Action and adventure
1 response
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 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