Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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?
Answers
-
I was able to get the following to work:
=COUNTIFS(Priority:Priority, "High", Status:Status, <>"Complete")
Hope this helps!:)
-
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.
-
@BethWork Glad you got it to work!:)
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!