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. However, 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").