Only count if column next to it contains

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-

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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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"))