Sum the number of cells in a row

Peter083

Board Regular
Joined
Feb 26, 2011
Messages
53
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.
 

Some videos you may like

Excel Facts

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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
Joined
Aug 15, 2004
Messages
1,413
Will this work for you?
Code:
=COUNTIF(C2:G2,">0")

HTH
Colin
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,336
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top