+ Reply to Thread
Results 1 to 7 of 7

SumIfs formula

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    SumIfs formula

    Hello:

    Please refer to attached file.
    I have monthly sheets with data per date as shown
    I need formulas in column K of sheet "Sum" to summarize the data in column K of "Sum" Sheet.
    I have manually added for Oct.

    Let me know if you have any questions.
    Thanks.

    R
    Attached Files Attached Files

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: SumIfs formula

    One way
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by mike7952; 11-24-2017 at 06:56 PM.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: SumIfs formula

    Hello:

    Thanks mike, this will work, will let you know if any problem.
    Riz

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: SumIfs formula

    Hello Mike:

    When i use at my end, it opens up file explorer, please have a look at attached pic
    Please let me know if you have any questions.
    Thanks.

    R
    Attached Images Attached Images

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: SumIfs formula

    Works on your example workbook. I'm not sure what's going on, on your end.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: SumIfs formula

    Hello Mike:

    I am totally confused...
    When i paste your formula, it opens explorer
    Not sure why????
    R

  7. #7
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: SumIfs formula

    Hello Mike:

    I got it, i found the mistake from my side.
    Thanks
    R

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumifs formula without using sumifs....
    By blockbyblock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2017, 10:45 AM
  2. Replies: 3
    Last Post: 01-24-2017, 08:08 AM
  3. Replies: 10
    Last Post: 12-16-2015, 03:16 PM
  4. [SOLVED] Sumifs formula giving #value even though each part individually works as a sum formula
    By carrach in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2015, 10:34 AM
  5. Replies: 2
    Last Post: 05-22-2014, 04:14 AM
  6. SUMIFS Puzzle - Trying to avoid adding multiple SUMIFS to get valid result
    By haldavid in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2013, 03:42 PM
  7. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM

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