Hello. I have a list of 4 names. Those names each have an ID number tagged
next to them. Throughout an array below that I have several (mini-tables)
that allow me to enter the tag and the cell next to the tag populates with
the name associated to that tag. Now, next to that name value is a cell where
I enter a number value for the number of home runs hit. Back at the top of
the page next to the kid's name, I'd like to look up from all of the
(mini-tables) everywhere on the page I see a given name nad somehow add all
of the number values next to the name values.

Summary:

I want one cell to have a formula that looks up the value 'John' in an array
I select and return the number next to that name after summing all occurances.

Thanks in advance!!!