Please Login or Register to view this content.
What is wrong with this formula? It returns a value of, well, #VALUE!
Please Login or Register to view this content.
What is wrong with this formula? It returns a value of, well, #VALUE!
Last edited by jonvanwyk; 12-12-2010 at 05:19 PM.
Hi Jon,
The problem is that you're combining SUM with a math function (+). No need to use + in between the ranges..
=SUM(Q158:Q163,Q166:Q171,Q174:Q179....)
If you use the Evaluate Formula toolbar option, you'll see that all of the range arguments after the first result in VALUE errors.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks