I have exported an Access crosstab query into Excel. Each row has a unique
identifier and I have 50 columns with different counts for each row. I need
to know which rows have counts in more than one column and how many columns
have a count in per row.

i.e. For Row 1 I would want to report a value of 1 as there is a value in
only one column, Row 2 I would want to report a value of 2 and Row 3 I would
want to report a value of 3. With 50 columns I need an easy way!!!

Column A Column B Column C
Row 1 6 0 0
Row 2 1 0 3
Row 3 4 1 1