+ Reply to Thread
Results 1 to 14 of 14

SUMIF problem

  1. #1
    Registered User
    Join Date
    07-20-2018
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    4

    SUMIF problem

    Hey boys, i am trying and trying and trying to make the SUMIF formula work. But i can't. So now i'm asking you, for help.

    Here is the problem:

    Example.PNG

    I would like to sum Column 2, 4, 6 and 8 IF the actual cell does NOT contain N/A.

    I am trying something like this: =SUMIF(C2,E2,G2,I2,"<>N/A",C2,E2,G2,I2) but it just doesn't work. Can anyone help me out here?

    Thank you so much!

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: SUMIF problem

    Funktionen SUMMA.OM

    SUMMA.OMF funktionen
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    07-20-2018
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    4

    Re: SUMIF problem

    That answer does not help me anything.
    Last edited by Kaitolito; 07-20-2018 at 02:12 AM.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: SUMIF problem

    click on link and read description about SUMIF or SUMIFS , how they works and how to use

  5. #5
    Registered User
    Join Date
    07-20-2018
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    4

    Re: SUMIF problem

    That answer doesn't help me anything.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: SUMIF problem

    pity, have a nice day

  7. #7
    Registered User
    Join Date
    07-20-2018
    Location
    Sweden
    MS-Off Ver
    2007
    Posts
    4

    Re: SUMIF problem

    I have already done that, and they does not cover how to use the formula on cells that are not next to each other on a row. That's the problem.

  8. #8
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,864

    Re: SUMIF problem

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  9. #9
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: SUMIF problem

    I just used this formula;
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And it gave me 90 as the result.

  10. #10
    Registered User
    Join Date
    06-25-2018
    Location
    Luna
    MS-Off Ver
    2013
    Posts
    46

    Re: SUMIF problem

    Quote Originally Posted by Kaitolito View Post
    they does not cover how to use the formula on
    cells that are not next to each other on a row
    @avk
    the question is how to skip the other columns (D,F,etc)

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,042

    Re: SUMIF problem

    No, but given the sample data, it doesn't matter - those columns are empty. This is why it's so important to provide realistic sample data - I imagine that in the real data they do contain data. Members here will offer solutions based on what they are given, not missing details.

    It's a bit late now, but the title to this thread is very vague. Titles should be more descriptive of the problem.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  12. #12
    Registered User
    Join Date
    06-25-2018
    Location
    Luna
    MS-Off Ver
    2013
    Posts
    46

    Re: SUMIF problem

    the original post already stated
    which 4 columns are to be added up
    -- implying we should skip data
    in any other columns.

    for those who missed this implication,
    OP came back in post #7 and stated it explicitly.

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,042

    Re: SUMIF problem

    Yes, so why did the OP not provide sample data that matched the requirement? The visuals and the written requirement don't match - that's my point.

    This is why it takes so long sometimes to reach what could have been a quick resolution. My comments are really for the OP to consider, and not meant as a criticism of any helpers in this thread.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    42,042

    Re: SUMIF problem

    This works (it ignores that N/A entries):

    =SUM(C2,E2,G2,I2)

+ 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. Excel 2007 : SUMIF Problem
    By HarrBhatt08 in forum Excel General
    Replies: 7
    Last Post: 12-10-2010, 03:13 PM
  2. SUMIF Problem
    By robertguy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2007, 06:19 AM
  3. SUMIF problem
    By ESPERANZA in forum Excel General
    Replies: 2
    Last Post: 09-05-2007, 10:37 AM
  4. sumif problem
    By hanm23 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-21-2006, 06:59 AM
  5. [SOLVED] SUMIF Problem
    By Rob in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 07:05 AM
  6. SUMIF Problem
    By Rob in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-06-2005, 04:05 AM
  7. SUMIF Problem
    By Mohammed Zenuwah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  8. SUMIF Problem
    By Sitios México in forum Excel General
    Replies: 5
    Last Post: 05-04-2005, 11:06 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