Countif for the number of a specific count?

S

sunilkeswani

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
 
S

sunilkeswani

Ardus,

I need to know the number of rows with a count of 2 in it, no.of rows
with count of 3 in it and so on. My spreadsheet will have appx 50000
rows filled with this data, so I dont want to copy the count formula
all over the sheet.

Was wondering if there was an easier formula possible...

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count 3
Count instances based on two criteria 2
complex sort search and replace macro 2
Count number of rows with specific text 2
Count Number of Rows 1
Counting results of a formula 9
COUNT rows on external sheet if between date range 3
Countif depending on the conditions across multiple columns 1

Top