Hi,

I have a spreadsheet with 12,000 rows of data.

Each row has data on the product and country it is sold.

The columns are basically labeled:

Product Name  Argentina Austria Brazil Belgium....and so on....

There are 50 column headers (One for each country our products are sold
in!).

I need to count how many countrys each product is sold in...

Unfortunately, where there is a positive result for a country in a row
- it is labeled with the country ISO code. i.e product A2 (cell
reference) is sold in Argentina, then in the ARgentina column, there is
the text input AR.

So, is there a way of counting all the columns that have text in them
and totalling up the count (i.e. 6 countries, 5 countries etc.) for
each row?

Regards

Jamie