Count number of cells matching to criteria
Solved/Closed
Rusty
-
Jan 16, 2009 at 02:17 PM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - Jan 16, 2009 at 03:56 PM
aquarelle Posts 7181 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - Jan 16, 2009 at 03:56 PM
Related:
- Count the number of cells that meet a criterion
- Google meet apk for pc - Download - Video calls
- Count number of occurrences in excel - Guide
- How to hide subscriber count - Guide
- Google meet remote access - Guide
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
1 response
aquarelle
Posts
7181
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
February 14, 2026
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
