Match and Sum?
 

Hello everyone, I have a 'jobs in progress' worksheet and I'm trying to
sum the total materials by work code.
column F has codes: Column AU has
material totals:
N
10
A
5
T
20
N
4
T
7
these codes will be repeated at random as the jobs are entered by
row. this is my formula =INDEX($AU$1:$AU$5,MATCH($A$1,$F$1:$F$5,0)
entered as an array. cell A1 has the code I want to find the sum for
eg. N . This formula returns only the first cell contents found matched
to N, eg. 10. and I would like it to return eg. 14. Thank you for your
help in advance, this forum has assisted me tremendously. J :confused:


--
Tiesthatbind


------------------------------------------------------------------------
Tiesthatbind's Profile: http://www.excelforum.com/member.php...o&userid=32360
View this thread: http://www.excelforum.com/showthread...hreadid=565844

Match and Sum?
 

i think i may have misunderstood your question but here goes..

Stick this formula in a spare cell (lets say A1)
=SUMIF(F:F,A2,AU:AU)

then use cell A2 to enter the code you want the sum of

so in your example if you had 'N' in cell A2, A1 would return 14 or if
A2 contained 'T', the result would be 27.

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=565844

Match and Sum?
 

Thanks so much! The SUMIF formula works perfectly, I was overthinking
it. J.:)


--
Tiesthatbind


------------------------------------------------------------------------
Tiesthatbind's Profile: http://www.excelforum.com/member.php...o&userid=32360
View this thread: http://www.excelforum.com/showthread...hreadid=565844