(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.