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
Bookmarks