I have a spreadsheet where Column A has cost codes; Column B has alternating rows that are for "Labor" and "Mat'l". The rest of the columns are for data input (labor hours or mat'l quantity) and there is one column for each week.
If I filter on cost code 065003, Labor rows for one week add up to 75 and Mat'l rows add up to 23. I can do that manually, but how do I tell Excel to place Labor sum on one row and Mat'l sum on a separate row for whatever cost code is in the filter? I can subtotal and get 75+23 but that's not the right answer; they need to be separated by filter, by labor and mat'l.
Display needs to look like this for each week:
Cost Code Labor: 75
Cost Code Mat'l: 23
Thanks,
November
Bookmarks