If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|