# Formula help?

#### Brew

##### Well-known Member
How do I create a formula that counts how many digits in cells AF1, AG1 and AH1 have digits 0, 1, 2, 3, or 4.

AH1=6
AG1=4
AF1=0
AP1=returns a result of 2,
because 0 and 4 in the AG and AF cells are within 0 and 4.
Thanks

### Excel Facts

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

#### CraigM

##### Active Member
A bit cumbersome, I know, but this should do it:

=SUM(COUNTIF(AF1:AH1,0),COUNTIF(AF1:AH1,1),COUNTIF(AF1:AH1,2),COUNTIF(AF1:AH1,3),COUNTIF(AF1:AH1,4))

#### Aladin Akyurek

##### MrExcel MVP
=SUMPRODUCT(--ISNUMBER(MATCH(AF1:AH1,{0,1,2,3,4},0)))

#### Brew

##### Well-known Member
Thanks Aladin and Craig. It works!!!!

Replies
5
Views
216
Replies
3
Views
162
Replies
1
Views
223
Replies
6
Views
196
Replies
13
Views
623

Threads
1,186,807
Messages
5,959,912
Members
438,453
Latest member
NRG909

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

### Disable AdBlock

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