formulas in excel

Occasional Contributor

How to create a quick formula without adding each line(to skip some line)...example..b3+b4+b5+b7+b8...?  thank you

7 Replies





This will sum all cells between B3 and B8.

but I do not want to add B6?



thank you! also why to I get (#VALUE!) and not the sum??
With both formulas?
no...another sum (F21:F27)???
That is a different question.
One or more of the cells contain a #VALUE! error.