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

I'm trying to figure out what formula will fill an if-then. I want to get the total number of YES's in column C there are if column B (on same row) contains "Phone". Total set has anywhere from 10 to 50 rows. I'm trying to separate how may YES Phone's there are within the set, and how many NO Phone's there are then have a running average.

Only count if column next to it contains
Display two columns in data validation list but return only one - Guide
Youtube subscriber count - Guide
Auto serial number in excel based on another column ✓ - Excel Forum
How to count names in excel - Guide
Excel copy column from one sheet to another automatically - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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"))

Similar discussions

Counting cells containing only numbers

how to count sentences in a paragraph..." using c language

Counting number of times a value appears if..

VBA find column by name and sort

Converting rows of data in notepad to columns

Similar discussions

Subscribe To Our Newsletter!