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

Countif rows
 

Hi

Try something like this:

=SUMPRODUCT((B1:E1="energy")*(B2:E5<""))

HTH
Jean-Guy

"Lauravila" wrote:

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

Countif rows
 

Assuming your header in row 1, and the Energy in column B and column C
=COUNT(B2:C100)


"Lauravila" wrote:

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