+ Reply to Thread
Results 1 to 9 of 9

SUMIF Error

  1. 05-23-2012, 03:26 PM #1
    skhari is offline
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Question SUMIF Error

    Hi Experts

    I am trying the calculate(SUM) the value IF C2 : C1000 = 5
    B2 : B1000 = Values (which I am trying to SUM)

    Attached for your reference.

    Please guide

    SK
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-23-2012, 04:07 PM #2
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: SUMIF Error

    You have your Calculation set to Manual.
    Click on Office Button - Options - Formulas - Calculations Options - set to automatic
    Reply With QuoteRegister To Reply
  3. 05-23-2012, 04:08 PM #3
    singerj6 is offline
    Registered User
    Join Date
    04-20-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2013, 2010, 2007, 2003
    Posts
    99

    Re: SUMIF Error

    You have Calculation Options set to "Manual". On Formulas tab, right side, click Calculation Options and change to "Automatic"
    SPARTAN
    Please click the * if my solution helped
    Reply With QuoteRegister To Reply
  4. 05-23-2012, 04:09 PM #4
    vandan_tanna is offline
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: SUMIF Error

    it is calculating for me!

    Is your workbook calculation method set to manual or automatic?
    Regards,
    Vandan
    Reply With QuoteRegister To Reply
  5. 05-23-2012, 04:09 PM #5
    singerj6 is offline
    Registered User
    Join Date
    04-20-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2013, 2010, 2007, 2003
    Posts
    99

    Re: SUMIF Error

    Beat me to it and the right version, well played Cutter, well played
    Reply With QuoteRegister To Reply
  6. 05-23-2012, 04:10 PM #6
    vandan_tanna is offline
    Valued Forum Contributor
    Join Date
    05-07-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    354

    Re: SUMIF Error

    Darn...I wasn't fast enough
    Reply With QuoteRegister To Reply
  7. 05-23-2012, 04:11 PM #7
    singerj6 is offline
    Registered User
    Join Date
    04-20-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2013, 2010, 2007, 2003
    Posts
    99

    Re: SUMIF Error

    Reputation handouts for all!
    (seriously)
    Reply With QuoteRegister To Reply
  8. 05-23-2012, 05:17 PM #8
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: SUMIF Error

    Beat me to it and the right version, well played Cutter, well played
    Thanks, and thanks for the 'star tap'.

    We seem to have lost the OP, though.
    Reply With QuoteRegister To Reply
  9. 05-23-2012, 10:48 PM #9
    skhari is offline
    Forum Contributor
    Join Date
    05-12-2012
    Location
    India, Chennai
    MS-Off Ver
    Excel 2003
    Posts
    182

    Thumbs up Re: SUMIF Error

    Simple !!! Thanks. I have learned this option now.Thanks for all experts
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1