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.


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.


Leave a Comment