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

@brunemboutlookcom 

Try:

=SUM(B3:B8)

 

This will sum all cells between B3 and B8.

but I do not want to add B6?

@brunemboutlookcom 

=SUM(B3:B8)-B6

=SUM(B3:B5,B7:B8)
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.