+ Reply to Thread
Results 1 to 6 of 6

sum based on criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: sum based on criteria

    how do i get the sum for the remaining headers? -4,-3,-2,-1....8

    on the sheet labeled blad1 it shows the aggregate total for Jun12, jul12, and aug12....how do i view it by month...i.e. jun12 totals, jul12 totals and aug12 totals separately? I do like being able to check/uncheck boxes to indicate which one i want included or excluded from the totals...

    thanks

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: sum based on criteria

    For excel 2007:

    Pull (in the pivot table) the month in sigma value.

    If you want to see only one month, you only select the wanted month.

    Do you have questions, just ask.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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