Hi,
I have an index match formula with multiple matches.
Column A Column B Column C Column D
2 Apple Apple
5 Cherry
4 Apple
What is the formula that I look up the Column C (Apple) and compare it to Column B. Then add up all the values in column A that match what is found in Column B. The formula should return the value "6" in column D.
This should be index match formula (I'm thinking that it is index match but it might be something else.
Thanks so much,
Jonathan
Not Index Match, Index Match for looking up values, you just SUMmed
in D1
=SUMPRODUCT((B$1:B$3=C1)*(A$1:A$3))
or
=SUMIF(B$1:B$3,C1,A$1:A$3)
Last edited by Special-K; 02-09-2012 at 06:47 PM.
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
How do I do the SUMIF over multiple pages?
Here is what I am trying to do...
SUMIF(('2-1-12'!E2:E48+'2-2-12'!E2:E48),Inventory!A2,('2-1-12'!C2:C48+'2-2-12'!C2:C48))
for the other equation I also get the same error #Value
=SUMPRODUCT(('2-1-12'!E2:E48+'2-2-12'!E2:E48+'2-3-12'!E2:E48)=Inventory!A2)*('2-1-12'!C2:C48+'2-2-12'!C2:C48+'2-3-12'!C2:C48)
I keep getting an error.
IT works if I am just using cells on one page.
How do I add cells for multiple pages?
Jonathan.
Last edited by jwaldmann; 02-09-2012 at 09:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks