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").
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/31743/excel-sumif-function-errors "