Only count if column next to it contains
Closed
Nanaia
-
Apr 6, 2010 at 09:46 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 6, 2010 at 10:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 6, 2010 at 10:26 AM
Related:
- Only count if column next to it contains
- How to count names in excel - Guide
- Display two columns in data validation list but return only one - Guide
- Excel count occurrences of string in column - Guide
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 6, 2010 at 10:26 AM
Apr 6, 2010 at 10:26 AM
This will give you over all total for item being phone and status being yes
=SUMPRODUCT((A:A="Phone") * (B:B="YES"))
This can give you running totals (presuming the first row of data is on row 2)
=SUMPRODUCT(($A$2:$A2="Phone") * ($B$2:$B2="YES"))
=SUMPRODUCT((A:A="Phone") * (B:B="YES"))
This can give you running totals (presuming the first row of data is on row 2)
=SUMPRODUCT(($A$2:$A2="Phone") * ($B$2:$B2="YES"))
