Thread: Countif rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lauravila Lauravila is offline
external usenet poster
 
Posts: 3
Default Countif rows

Hi,
I have the info in the following format:
Sector: Energy Energy Industrials Industrials Comm
1 2 10
11
4 10 6 7
8

Each column is a different company. For each row I would like to count how
many nonblanksmare in the Energy sector, then Industrial, etc. What do I need
to do?
Thank you,
Laura