Multiple columns using countifs
Closed
jclegg42002
Posts
1
Registration date
Saturday 6 September 2014
Status
Member
Last seen
6 September 2014
-
6 Sep 2014 à 07:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Sep 2014 à 02:11
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 7 Sep 2014 à 02:11
Related:
- Multiple columns using countifs
- Excel drop down list multiple columns - Guide
- How to delete columns in word - Guide
- Split excel sheet into multiple files - Guide
- How to delete multiple files on mac - Guide
- Mpc hc multiple instances - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
7 Sep 2014 à 02:11
7 Sep 2014 à 02:11
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"))