| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count text occurences in range when criteria in other column is me
I have a spreadsheet with data like this:
J K L Q 1 GIFT #1 GIFT #2 GIFT #3 DELIVER 2 APRON Camcorder Clock Yes 3 Stereo Apron Yes 4 Camera 6 APRON Yes 7 APRON Clock 8 Clock Yes I want to count occurences of "Apron" in range J2:J8 ONLY if "Yes" occurs in Column Q of that record (row). The total will be in a different sheet of teh same workbook (The sheets are named.) Any suggestions how to accomplish this? I tried COUNTIF, SUMIF, SUMPRODUCT. Nothing gave the proper result. I either received an error (#NAME or #VALUE) ot the wrong result (0). Any suggestions are appreciated. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurences of text in range only when Yes appears in other c | Excel Worksheet Functions | |||
| count occurences meeting criteria | Excel Worksheet Functions | |||
| How do I count the # of unique occurences of a text in a column? | Excel Worksheet Functions | |||
| count text occurences in a column | Excel Discussion (Misc queries) | |||
| How do I count occurences in a date range? | Excel Worksheet Functions | |||
Threaded Mode
