| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Multiple with text
Hi,
Need help. How do I count a datasheet for the number of rows which have the number 208 in Column C and "Yes" in Column M? I can only do a basic COUNTIF, but dont know how to get this Cheers Sunny |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Multiple with text
Sunny
You could use sumproduct() =SUMPRODUCT(--(C2:C50=208),--(M2:M50="Yes")) I have assumed that your data is in rows 2 to 50, you can adjust as required. Let me know if this works for you. Dave wrote in message oups.com... Hi, Need help. How do I count a datasheet for the number of rows which have the number 208 in Column C and "Yes" in Column M? I can only do a basic COUNTIF, but dont know how to get this Cheers Sunny |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Multiple with text
Dave,
This works just fine, thank you very much ! Cheers Sunny |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Countif Multiple with text
Glad to help
Dave wrote in message ups.com... Dave, This works just fine, thank you very much ! Cheers Sunny |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to select multiple text boxes in excel for formatting | New Users to Excel | |||
| Returning Multiple Text or Address Locations | Excel Worksheet Functions | |||
| seperating text in one cell to multiple cells | Excel Discussion (Misc queries) | |||
| Multiple Text files into one worksheet-need help | Excel Discussion (Misc queries) | |||
| vertical text across multiple cells | Excel Discussion (Misc queries) | |||
Linear Mode
