# Sum the number of cells in a row

#### Peter083

##### Board Regular
Hi, can someone please help with the following. If I have 20% in C2, 30% in D2, 40% in E2, 0% in F2 and 0% in G2. I am trying to find a way that I can add these cells iin H2 so that H2 returns 3 (3 cells in Row 2 have been filled in) and not the sum of 20,30,40,0,0. I would guess its some kind of formatting but I can't figure it out after 3 days.

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### stilesbn

##### Board Regular
In H2 put

Code:
``=COUNTIF(C2:G2,">"&0)``

##### MrExcel MVP
Hi, can someone please help with the following. If I have 20% in C2, 30% in D2, 40% in E2, 0% in F2 and 0% in G2. I am trying to find a way that I can add these cells iin H2 so that H2 returns 3 (3 cells in Row 2 have been filled in) and not the sum of 20,30,40,0,0. I would guess its some kind of formatting but I can't figure it out after 3 days.

Try...

=SUM(COUNTIF(C2:G2,{"<0",">0"}))

#### rs2k

##### Well-known Member
Will this work for you?
Code:
``=COUNTIF(C2:G2,">0")``

HTH
Colin

#### Peter083

##### Board Regular
works perfectly thank you so much

Replies
3
Views
32
Replies
1
Views
37
Replies
1
Views
41
Replies
3
Views
47
Replies
5
Views
54