# countifs help

#### Flashboy

##### New Member
trying to do a countifs that keeps returning 0 when I know there should be a count of 11.

This is the formula I'm using, I need to be able to put the individual criteria in such as BVH111 just not sure if I'm doing it right? any help would be great.

=COUNTIFS(Data!\$CA:\$CA,'NS Dashboard'!D5,Data!\$H:\$H,BVH151+BVH152+BVH153+BVH154+BVH155+BVH156+BVH157+BVH161+BVH162+BVH162+BVH163+BVH164+BVH165+BVH166+BVH167)

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
The way that formula is writtin, it will first ADD the values in each of those cells (BVH151 through BVH167)
Say those add up to 35 or whatever.
Then 35 becomes the criteria it searches column H for
=COUNTIFS(Data!\$CA:\$CA,'NS Dashboard'!D5,Data!\$H:\$H,BVH151+BVH152+BVH153+BVH154+BVH155+BVH156+BVH157+BVH161+BVH162+BVH162+BVH163+BVH164+BVH165+BVH1 66+BVH167)
=COUNTIFS(Data!\$CA:\$CA,'NS Dashboard'!D5,Data!\$H:\$H,35)

Is that what you're intending it to do?

Or are you trying to have an OR criteria for column H
Count if Column H = BVH151 OR BVH152 OR BVH153 etc.. ??

For that you would do
=SUMPORODUCT(COUNTIFS(Data!\$CA:\$CA,'NS Dashboard'!D5,Data!\$H:\$H,\$BVH\$151:\$BVH\$167))

I can see a typo error in the equation. Towards the right. BVH1 66 may need to be BVH166.

What I was trying to do is count if it find all of the BVH numbers stated above. as there are 100's more but I just want them to be included if that makes sense?

Did you try the formula I posted?

Yea didn't work at first but then spotted why, had an extra O in sumproduct . Thanks Your a star!

It sure did dint it
Good catch.

Replies
2
Views
314
Replies
5
Views
233
Replies
2
Views
296
Replies
5
Views
212
Replies
3
Views
258

1,196,408
Messages
6,015,102
Members
441,870
Latest member
kojack

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