Hello all! I need a formula that looks in Column A for a match to the contents of cell A1. There will be multiple matches in the column. For each match found I would like excel to sum the contents of each respective cell in column B. Example posted.
Hello all! I need a formula that looks in Column A for a match to the contents of cell A1. There will be multiple matches in the column. For each match found I would like excel to sum the contents of each respective cell in column B. Example posted.
Last edited by mightyeskimo; 10-07-2011 at 02:41 PM.
mightyeskimo,
Give this a try:
=SUMPRODUCT(--($A$1:$A$6=A1),$B$1:$B$6)
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
mightyeskimo,
Alternate version:
=SUMIF($A$1:$A$6,A1,$B$1:$B$6)
Thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks