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...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/31743/excel-sumif-function-errors "