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