# 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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### 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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,031
Messages
5,856,936
Members
431,841
Latest member
jaybeem

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back