Counting Entries across a row

[rowlo-efc]

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

 

[Pete_UK]

Try this:

=COUNTA(B2:AY2)

And copy down your 12,000 rows.

Hope this helps.

Pete

 

[rowlo-efc]

Works a treat - Thanks Pete_UK

Kindest Regards

Jamie

 

[Pete_UK]

You're welcome.

Pete