I'm looking at your file...

It's not real clear what you want to do based on your posted formula:

=IF(OR(COUNT(Races!$AG$2:$AG$5000)<0,COUNT(Races! $AG$2:$AG$5000)<"",COUNT(Races!$AG$2:$AG$5000)<" B",COUNT(Races!$AG$2:$AG$5000)<0)),"-",COUNT(Races!$AG$2:$AG$5000)),0)

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


"Brian" wrote in message
...
(moved from general) I am trying to take the data from the Races sheet and
have certain parts counted, summed, or averaged by track into the Track
Stats
sheet. I'm really not sure how to go about starting this as it will need
to
look through each line and determine if the results are from that track.
This is too complicated to explain thoroughly so I posted a link to the
sheet
is below.

Link: http://www.zshare.net/download/1725482392a76ca7
It contains a couple of macros for determining sheet names etc...

For one explainable example, I am trying to have the Track Stats sheet
look
through up to 5000 entries on the Races sheet and count the number of
starts
for a given track based on the criteria that the range does not equal
0,"","B", or "DNS". I'm thinking it would be framed similar to this but
it
isn't working for the whole range...

=IF(OR(COUNT(Races!$AG$2:$AG$5000)<0,COUNT(Races! $AG$2:$AG$5000)<"",COUNT(Races!$AG$2:$AG$5000)<" B",COUNT(Races!$AG$2:$AG$5000)<0)),"-",COUNT(Races!$AG$2:$AG$5000)),0)

Atlanta would be a good test case on the Track Stats sheets as it is the
first in the list that should pop up numbers. Any help or direction is
appreciated.