+ Reply to Thread
Results 1 to 5 of 5

Getting output 0 sumif formula

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Getting output 0 sumif formula

    Hi friends,

    There are names of items in column B
    There is a cost of each item in column D

    I want to sum of each item in column G
    The names of each item is in column F

    I have used a combination of sum, sumif, or functions to get a total amount of each item in column G

    There is a output require in column H

    At present I’m getting a total of each item 0 which should be as per the output in column H

    Any help will be highly appreciated.

    Thanking you.
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: Getting output 0 sumif formula

    Here!

    =SUMIF($B$2:$B$15,F2,$D$2:$D$15)

    Put it in G2 and Drag down
    Cheers!
    Deep Dave

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Getting output 0 sumif formula

    Put in G2 and dragged down:

    =SUMIF($B$2:$B$100,$F2,$D$2:$D$100)

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Getting output 0 sumif formula

    hi

    use this in i g2 and drag it down and also adjust the range as per your requirement .

    Formula: copy to clipboard
    =SUMIF($B$2:$B$15,F2,$D$2:$D$15)


    Punnam

  5. #5
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Getting output 0 sumif formula

    Hi all,
    Oops!

    What a silly mistake. Unnecesarily I had gone from simple to complicated.

    Now, it's working fine.

    Thank you to you all for your kind support.

+ 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] Index Match Formula doesn't recognize output from Right Formula as lookup value.
    By GoGators in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-10-2015, 11:33 AM
  2. [SOLVED] Countif with Sumif is producing a single error in output
    By sipa in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 12-30-2014, 07:34 AM
  3. Replies: 1
    Last Post: 01-06-2014, 03:54 AM
  4. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  5. Is VBA possible on this output or does this require just a SUMIF formula?
    By geng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2010, 03:24 AM

Tags for this Thread

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