Multiple columns using countifs
Closed
jclegg42002
Posts
1
Registration date
Saturday September 6, 2014
Status
Member
Last seen
September 6, 2014
-
Sep 6, 2014 at 07:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 7, 2014 at 02:11 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 7, 2014 at 02:11 AM
Related:
- Multiple columns using countifs
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
- Photoshop multiple selections - Guide
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 7, 2014 at 02:11 AM
Sep 7, 2014 at 02:11 AM
suppose last row is 10
=sumproduct((A2:A10="VGN")*(N2:N10="WON")*(N2:N10="PENDING"))
=sumproduct((A2:A10="VGN")*(N2:N10="WON")*(N2:N10="PENDING"))