Count number of cells matching to criteria
Solved/Closed
Rusty
-
Jan 16, 2009 at 02:17 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Jan 16, 2009 at 03:56 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Jan 16, 2009 at 03:56 PM
Related:
- Count the number of cells that meet a criterion
- Google meet download for pc - Download - Video calls
- Google meet camera not working - Guide
- How to count names in excel - Guide
- If a cell has text then return value ✓ - Excel Forum
- Google meet extension - Guide
1 response
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Jan 16, 2009 at 03:56 PM
Jan 16, 2009 at 03:56 PM
Hello,
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards
Try this formula :
=SUMPRODUCT((A1:A10=1)*(B1:B10="A"))
Best regards