+ Reply to Thread
Results 1 to 5 of 5

need formula SUMIFS is not working

  1. #1
    Forum Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    251

    need formula SUMIFS is not working

    Dear all
    I am maintaining excel this is daily entering what v r buying. A Column is date b Column is iteam C Column is amount i want iteam wise Total. I using this formula =SUMIFS(C:C,B:B,E4) But it Not working because is kg is add. So I need some help. I attached sample sheet also.
    Attached Files Attached Files
    Last edited by sudbhavani; 02-09-2021 at 03:24 AM.

  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,917

    Re: need some help in formula

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    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 Contributor
    Join Date
    02-04-2017
    Location
    chennai
    MS-Off Ver
    MS OFFICE 365
    Posts
    251

    Re: need some help in formula

    ok thanks kindly give the solution

  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,917

    Re: need formula SUMIFS is not working

    This would be MUCH simpler if you kept numbers and text separate. I would put TYPE in it's own column, Amount in it's column and Unit in it's own column - this will also make entering data easier too.

    This way, your formula works fine...
    A
    B
    C
    D
    E
    F
    G
    H
    1
    date iteam amount
    2
    1/9/2021
    mutton
    5
    kg
    2000
    3
    1/9/2021
    mutton
    10
    kg
    5000
    4
    1/10/2021
    mutton
    3
    kg
    1500
    mutton
    19600
    5
    1/11/2021
    mutton
    5
    kg
    2000
    Chicken
    4700
    6
    1/15/2021
    mutton
    6
    kg
    2100
    7
    1/16/2021
    mutton
    15
    kg
    7000
    8
    1/9/2021
    chicken
    1
    kg
    200
    9
    1/9/2021
    chicken
    5
    kg
    1000
    10
    1/9/2021
    chicken
    3
    kg
    600
    11
    1/10/2021
    chicken
    3
    kg
    600
    12
    1/11/2021
    chicken
    10
    kg
    2000
    13
    1/15/2021
    chicken
    1
    kg
    100
    14
    1/16/2021
    chicken
    2
    kg
    200


    H4=SUMIFS(E:E,B:B,G4)
    copied down

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: need formula SUMIFS is not working

    Quote Originally Posted by sudbhavani View Post
    But it Not working because is kg is add
    Try this:

    =SUMIFS(C:C,B:B,E4&" *")

+ 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. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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