Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Subtotals based on value in other cell

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Arkansas
    Posts
    157
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to subtotal the values in a column (e.g. column A), based on what is filtered in column B (weekly total), and/or column C (monthly totals). For example, if week 13 is selected using the autofilter, it will calculate what is filtered and produce a weekly total based only on what is filtered. If I filter "all", it will add all of that column, and update monthly total as well. Can I do this without a macro? I'd like to know the best way to do this with and without a macro. The formula I have now doesn't calculate correctly when I filter a specific week.

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perhaps you just need a sumif?
    ~Anne Troy

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Arkansas
    Posts
    157
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried a sumif, but can't get it to work if I filter for only 1 week. Any ideas?

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-30 04:25, boydr wrote:
    I tried a sumif, but can't get it to work if I filter for only 1 week. Any ideas?
    That would indicate that you don't have a column in your data area which houses week numbers.

    If you want to, post 10 rows of your data you're autofiltering: Activate an empty cell, type =, select 10 rows of data including the labels, hit F9, Copy what you see, and post the copied bit here in an follow-up posting.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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