I think you are misunderstanding what I was doing to quality control the
results. I know COUNT and SUM are two different things. However, I used sum
to add up the COUNTS from you formula, and then compared them to the number I
counted manually. I counted 517 manual, and the SUM of the COUNTS totalled
492. Hence I am trying to figure out where the discrepancy is and if I can
control for it. That was the reason I asked this:

Is there a way to make it so that you can only choose a track on the Races
sheet (column W) that is included in the list box?

"T. Valko" wrote:

=SUMPRODUCT(--(Tracks=$C3),--(ISNUMBER(Finished)))

That formula is *counting*.

=SUM(E$3:E$1002)

That formula is *summing*.

Those are entirely different formulas and can not be used to compare
results.

Also I used SHFT+CTRL+ENTER as I think it has to be done with arrays?

Not needed in this case.


--
Biff
Microsoft Excel MVP


"Brian" wrote in message
...
First, thanks for the help......

Yes, I am wanting to calculate, for each individual track, the relevant
stats. Your formula seemed to work pretty good to count the number of
starts
at a given track. I copied the formula as

=SUMPRODUCT(--(Tracks=$C3),--(ISNUMBER(Finished)))

to each cell in column E but I am a bit perplexed that when I summed it at
the top of the Track Stats sheet with

=SUM(E$3:E$1002)

....it added up 492 starts. The problem is that I know there is 517.
Even
manually counted them. Not sure if 25 of the track names were entered
incorrectly or with spaces? Is there a way to make it so that you can
only
choose a track on the Races sheet (column W) that is included in the list
box?

Also I used SHFT+CTRL+ENTER as I think it has to be done with arrays?

=SUMPRODUCT(--(Tracks=$C9),--(ISNUMBER(Finished)))

Is that correct?




"T. Valko" wrote:
My best guess is that you want to count only cells that are numbers and
greater than 0 but there are no zeros in that range.

So, try this:

=SUMPRODUCT(--(Tracks="Atlanta"),--(ISNUMBER(Finished)))

--
Biff
Microsoft Excel MVP