Sum the number of cells in a row

[Peter083]

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.

 

[stilesbn]

In H2 put

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

 

[Aladin Akyurek]

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]

Will this work for you?

=COUNTIF(C2:G2,">0")

HTH
Colin

 

[Peter083]

works perfectly thank you so much