ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   COUNTA or COUNTIF or COUNT (https://www.excelbanter.com/excel-worksheet-functions/265280-counta-countif-count.html)

Liz
COUNTA or COUNTIF or COUNT
 
Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?

--
Thanks - liz

Luke M[_4_]
COUNTA or COUNTIF or COUNT
 
=SUMPRODUCT(--(C3:C5="YES"),--(B3:B5="Bill"))

--
Best Regards,

Luke M
"Liz" wrote in message
...
Trying to count the times "YES" occurs in column C3:C5 for each time
"Bill"
indicated in column B3:B5?

--
Thanks - liz



Don Guillett[_2_]
COUNTA or COUNTIF or COUNT
 
=sumproduct((b3:b5="bill")*(c3:c5="yes"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Liz" wrote in message
...
Trying to count the times "YES" occurs in column C3:C5 for each time
"Bill"
indicated in column B3:B5?

--
Thanks - liz


Steve
COUNTA or COUNTIF or COUNT
 
Try
=COUNTIFS(C3:C5,"YES",B3:B5,"Bill")

Regards
Steve

"Liz" wrote:

Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?

--
Thanks - liz

Don Guillett[_2_]
COUNTA or COUNTIF or COUNT
 
xl2007

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
Try
=COUNTIFS(C3:C5,"YES",B3:B5,"Bill")

Regards
Steve

"Liz" wrote:

Trying to count the times "YES" occurs in column C3:C5 for each time
"Bill"
indicated in column B3:B5?

--
Thanks - liz



All times are GMT +1. The time now is 06:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com