Count Values within a range

Hi,
I would like a formula to count number of values within a range.
Please refer worksheet

Thanks

Ian
Number-Values.xlsx
raceproretiredAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Okay, please try this...

In C2
=COUNTIFS($A$2:$A$22,A2,$B$2:$B$22,"<>")

Open in new window

and copy it down.
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
It's not clear what you are counting. Can you please explain the logic behind the desired output you showed in column C?
0
 
raceproretiredAuthor Commented:
I'm counting the number of values in column B of the sheet I attached.
As an example there are 3 values associated with index number 12.
0
 
raceproretiredAuthor Commented:
Thanks once again Neeraj. You are outstandingly talented.
Ian
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome Ian! Glad it worked as desired.
Thanks for the compliment. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.