# COUNT Problem

#### dknowles2004

##### Board Regular
Hi

I want to count a range of values in Excel (not VBA) so that:

1. If value = 0 then disregard
2. If value = any other value then count count 1 for each instance

For example,
A1 = 0
A2 = 0
A3 = NISS
A4 = FDIA

Count value is therefore 2.

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### fairwinds

##### MrExcel MVP
Hi,

Try:

=COUNTIF(A1:A10,"<>0")

#### Juan Pablo González

##### MrExcel MVP
=COUNTIF(YourRange, "<>0")

or

=COUNTA(YourRange) - COUNTIF(YourRange, 0)

Replies
2
Views
111
Replies
0
Views
200
Replies
1
Views
296
Replies
1
Views
131
Replies
13
Views
301

1,181,786
Messages
5,932,041
Members
436,816
Latest member
Composh

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