Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- Tiesthatbind ------------------------------------------------------------------------ Tiesthatbind's Profile: http://www.excelforum.com/member.php...o&userid=32360 View this thread: http://www.excelforum.com/showthread...hreadid=565844 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|