Results 1 to 31 of 31

Combining sumif, subtotal with filters?

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2006
    Posts
    13

    Combining sumif, subtotal with filters?

    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
    Last edited by November; 11-04-2006 at 12:47 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1