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 at once - Guide
- Excel data validation list from table multiple columns - Guide
- Photoshop multiple selections - Guide
- Which key is used to make multiple line in a single cell - 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"))