Formula says #INVALID OPERATION.

I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION.

=SUM(COUNTIF(Priority:Priority, "High") - (COUNTIFS(Priority:Priority, "High", Status:Status, "Complete")))

The Priority column is a symbol column and they are high medium low so I'm not sure where the issue is. It was originally a column with a formula in it, but it still had the same error. What can I do to fix it?

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

brianschmidt

I was able to get the following to work:

=COUNTIFS(Priority:Priority, "High", Status:Status, <>"Complete")

Hope this helps!:)

BethWork

@brianschmidt

I tried your formula and got the same error. I did fix it though. It seems that in several rows above all of the symbols were populating the cells using a formula. Once I deleted the formulas from those cells it immediately summed all of the High status cells together.

brianschmidt

@BethWork Glad you got it to work!:)

sfogel

I had a similar issue. I had to convert a column formula to cell formula, delete the formula from the cell that was giving the Invalid Operation error, then turn the formula back to a column formula.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.