Excel Sum Array Formula
 

Thank You, That is what I was looking for....works better not to call
anything out specifically then the list can change without having to re-
evaluate the formula.

engoo wrote:
You may modify the formula to refer to the corresponding value in
Column A for each row:

=SUMIF(A:A,A2,B:B)

Enter this formula in Cell C2 and copy it down for all rows..

On May 24, 12:14 pm, Tom Ogilvy
wrote:
also look at using a pivot table report under the data menu.

[quoted text clipped - 50 lines]

- Show quoted text -

--
Message posted via http://www.officekb.com