Sounds like you need a SumIf formula. If not, provide a small sample
along with the expected result.
SP wrote:
> 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!!!
Bookmarks