| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTA or COUNTIF?? | Excel Discussion (Misc queries) | |||
| Need help with Count, Counta, Countif | Excel Discussion (Misc queries) | |||
| If with countif or counta | Excel Worksheet Functions | |||
| Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
| CountIF, CountA,Which one? or neither? | Excel Discussion (Misc queries) | |||
Linear Mode
