| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif for the number of a specific count?
Hi,
I have 4 columns on a spreadsheet, which have data on it. Some columns maybe blank. I need a count of the count (i.e) I want to know how many rows have a count of 1, how many have a count of 2, and 3 and 4. Heres an example A B C D 111 111 111 122 133 221 The result will be Rows with 1 code = 1 Rows with 2 codes = 1 Rows with 3 codes = 1 Rows with 4 codes = 0 Please help ! Cheers Sunny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Count cells with specific values in the cells next to them? | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
| Function to Count Number of Consecutive Rows with a Specific Criteria? | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Threaded Mode
