Count values formula in series

Hi,
I would like a formula to count how many values in each series.
Please see attached.
Many thanks
Ian
Countvalues.xlsx
raceproretiredAsked:
Who is Participating?
 
Subodh Tiwari (Neeraj)Connect With a Mentor Excel & VBA ExpertCommented:
Hi Ian,

Please try this...

In C2
=COUNTIFS($B$2:$B$17,">0",$A$2:$A$17,A2)

Open in new window

and then copy it down.
1
 
raceproretiredAuthor Commented:
Wow that was quick !!  you must have been  polishing your computer :)
Perfect
Thanks Neeraj
Ian
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You'r welcome Ian! :) :)
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
raceproretiredAuthor Commented:
Just noticed if no values in a series then I get a "VALUE" error
0
 
raceproretiredAuthor Commented:
Sorry, all okay now, my mistake.
1
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Can you upload a sample file along with that issue?
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Okay, glad all resolved. :)
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.