+ Reply to Thread
Results 1 to 8 of 8

USING SUMIFS formula returns a '0' for me

  1. #1
    Registered User
    Join Date
    03-11-2015
    Location
    Cleveland, Ohio
    MS-Off Ver
    2013
    Posts
    5

    Question USING SUMIFS formula returns a '0' for me

    I will make reference to the attached spreadsheet. I am trying to use a SUMIFS formula to return results to Column T, however I am just getting goose eggs. Basically, Column 'T' is to add up the total hours from column 'I' for each Equipment ID from Column 'K' and Column 'A'. As you will see the Equipment ID in Column 'A' is a vastly long list, thus the reasoning for Columns K, and so on... to parse down the data. I was able to use SUMIFS for some of the other parts, however, this one is not working for me.

    A successful SUMIFS went as follows =SUMIFS($G:$G,$D:$D,P$1,$A:$A,$K4)

    The SUMIFS for Column T for the hours has not worked I have tried different variations like.. =SUMIFS($I:$I,?????,T$1,$A:$A,$K4) with the question mark section being different setting. Maybe a SUMIFS is not the answer here?

    I hope this makes sense! haha Any help would be much appreciated. Thanks!!!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: USING SUMIFS formula returns a '0' for me

    Hi, welcome to the forum

    I havent tested all columns, but...
    column L, only row 2 has "Liquids Unloading with Plunger Vent Time"
    Column M, only row 3 has "Casing Pressure"
    N "Tubing Pressure" in row 4

    It looks to me like your formulas are working correctly, you just dont have any data that matches your criteria
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: USING SUMIFS formula returns a '0' for me

    Which is your actual resulting column?

    Column G or Column I?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: USING SUMIFS formula returns a '0' for me

    @ Six, I think they all are, based on data from column K and then the headings for each column L:S

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: USING SUMIFS formula returns a '0' for me

    Quote Originally Posted by FDibbins View Post
    @ Six, I think they all are, based on data from column K and then the headings for each column L:S
    Ah!!! I missed that whole part

    Thanks for clarifying it

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: USING SUMIFS formula returns a '0' for me

    As Ford explained there is no matching value Hours of Operation (T1 Cell Value) found on the range D:D

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: USING SUMIFS formula returns a '0' for me

    Took me a few minutes to see that too

  8. #8
    Registered User
    Join Date
    03-11-2015
    Location
    Cleveland, Ohio
    MS-Off Ver
    2013
    Posts
    5

    Re: USING SUMIFS formula returns a '0' for me

    Ah right! Thanks for finding that. So, instead of D:D range. Is it possible to find another range to match Hours of Operation, or try a new formula all together to get those totals? Thanks!

+ 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 returns error
    By kronikjb in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-08-2015, 12:51 PM
  2. [SOLVED] Sumifs returns zeroes
    By Bob Macregor in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-01-2014, 07:17 AM
  3. [SOLVED] SUMIFS returns a zero value
    By jtc121 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-07-2014, 06:29 AM
  4. Sumifs formula returns ZERO
    By Xx7 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-10-2013, 02:05 PM
  5. SUMIFS returns VALUE!
    By mogdog1981 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2011, 04:38 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