+ Reply to Thread
Results 1 to 3 of 3

Using a SUMIF formula and not sure if this is correct

  1. #1
    Registered User
    Join Date
    05-14-2014
    MS-Off Ver
    Excel 2003
    Posts
    5

    Using a SUMIF formula and not sure if this is correct

    I have about 100 rows of data in column A and values against each in B. I was trying to construct a SUMIF formula to pull specific names out of Column A and sum the totals from B. I can get the formula to work if I just ask for one criteria but when I add multiple I gets errors.

    =SUMIF(A1:A4,"=Product",B1:B4) - This works if I am just looking for products but when I try to also bring in totally Products, Sales and distribution into this formula it errors.

    Any help would be appreciated.

    cheers
    Barry

  2. #2
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Using a SUMIF formula and not sure if this is correct

    Please post sample file with correct answer that you need.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Using a SUMIF formula and not sure if this is correct

    Can you post a sheet?

    If you'd read my original text, forget it... senior moment here.
    Last edited by Glenn Kennedy; 05-30-2014 at 03:33 AM. Reason: talking rubbish...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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] The formula is correct but one cell does not return correct value
    By nkhondeya@gmail.com in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2013, 03:08 PM
  2. [SOLVED] How to input the correct SUMIF formula?
    By dcmoser1952 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2013, 12:58 AM
  3. SUMIF with INDIRECT is not generating correct value
    By suresh_edk in forum Excel General
    Replies: 5
    Last Post: 11-30-2010, 04:44 AM
  4. SUMIF - correct function?
    By maddog9486 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2009, 09:52 AM
  5. Is SUMIF correct?
    By mckielj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-30-2006, 04:10 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