Excel SUMIF function errors — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Excel SUMIF function errors

by on
in Excel Training,Office Technology

Q. This SUMIFs formula keeps getting an error that says, “The formula you typed contains an error." Here’s what I wrote: -SUMIF(C2:C278,>1000). What is causing the error?

A. One of the most common missteps in a SUMIF statement is to forget to put the criteria in double quotes (“”). Typically, you put double quotes only around function arguments that contain text strings. How­­ever, in a SUMIF, you must put all criteria, except a single value, in double quotes for it to be syntactically correct. Your formula should read =SUMIF(C2:C278,">1000").

Make sure your SUMIF statement is in double quotes

{ 2 comments… read them below or add one }

vba August 29, 2012 at 5:19 pm

Learn vlookup, excel hlookup, sumif , vba etc.We are excel consultant and access programmer with expertise in advanced Excel formulas, modeling, macros, and VBA.

Reply

Excel Expert August 29, 2012 at 8:16 am

We are excel consultants and excel expert, Having 15+ years experience with Excel and Access programming, VBA (for programming in Excel and Access) MySQL, Oracle, ODBC, PHP, and much more.

Reply

Leave a Comment