# count '0' but not blank cells

#### Roses8

##### Active Member
=SUMPRODUCT(--(Backsheet!\$R\$2:\$R\$1001>=0),--(Backsheet!\$R\$2:\$R\$1001<=3))

Hi I have this formula, however I need it to count the number of zero's however it is counting all the blank cells as well, is there way of getting around this?

Thanks.

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

#### Andrew Poulsom

##### MrExcel MVP
Try:

=SUMPRODUCT(--ISNUMBER(Backsheet!\$R\$2:\$R\$1001),--(Backsheet!\$R\$2:\$R\$1001>=0),--(Backsheet!\$R\$2:\$R\$1001<=3))

#### NBVC

##### Well-known Member
=SUMPRODUCT(--(Backsheet!\$R\$2:\$R\$1001<>""),--(Backsheet!\$R\$2:\$R\$1001>=0),--(Backsheet!\$R\$2:\$R\$1001<=3))

#### Roses8

##### Active Member
thats great, thank u so much.

#### Scott Huish

##### MrExcel MVP
Code:
``=COUNTIF(Backsheet!\$R\$2:\$R\$1001,">=0")-COUNTIF(Backsheet!\$R\$2:\$R\$1001,">3")``

Replies
30
Views
432
Replies
3
Views
653
Replies
3
Views
92
Replies
5
Views
100
Replies
9
Views
113

1,141,630
Messages
5,707,511
Members
421,511
Latest member
mgroah1

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

### Which adblocker are you using?

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

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