Enter in A10:
=COUNTA(A1:A3)
then copy to the right

HTH
--
AP


a écrit dans le message de news:
...
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