Results 1 to 4 of 4

Calculating Subtotals for Different Categories

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Calculating Subtotals for Different Categories

    Hi guys,

    I have a sheet made for tracking refunds by catagory, but am having a hard time getting catagorized subtotals.

    There are 5 different refund codes (A, B, C, D, E) and at the top of the sheet I want to be able to break down the refund totals by catagory. So I need something like "If any cell in G11:G93="C", include in the total in cell B3, If Any cell in G11:G93=B, include in the total in cell B2. etc." I've been trying to learn the SUBTOTAL function, but am not having much luck. Unfortunately the sheet is not sorted by refund code, otherwise it would be a simple task. Any and all ideas are welcome, thanks in advance.

    -Brandon
    Last edited by DerStro; 05-12-2011 at 12:07 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