excel Formula - sum only visible cells with multiple criteria
Results 1 to 3 of 3

Thread: excel Formula - sum only visible cells with multiple criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2003
    Posts
    1,557
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default excel Formula - sum only visible cells with multiple criteria

    I found the following thread:

    https://www.mrexcel.com/forum/excel-...ells-only.html

    which is great and I love it, but I need to basically do a SUMIFS on visible cells. so How would I put that together?

    Thanks,
    Stolen from Micron

    Tips for posting problems:
    1) "doesn't work" is of no help. Post error message numbers and text, if known.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    your title should be as descriptive as possible:
    i.e. VBA 2013 ERROR - object or variable not set issue

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,732
    Post Thanks / Like
    Mentioned
    458 Post(s)
    Tagged
    45 Thread(s)

    Default Re: excel Formula - sum only visible cells with multiple criteria

    That's exactly what the formula you linked to does.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,383
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: excel Formula - sum only visible cells with multiple criteria

    Note that "SUMPRODUCT" was what we used to used to do "SUMIFS" before "SUMIFS" existed!
    While SUMIFS exists now, there are still some more complex situations that will require you to use SUMPRODUCT instead.

    Basically, any formula that you come up with using COUNTIF, COUNTIFS, SUMIF, or SUMIFS can also be done with SUMPRODUCT.
    But SUMPRODUCT is more flexible, and can do more complex calculations.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Some videos you may like

User Tag List

Tags for this Thread

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
  •