Forum Discussion
formulas in excel
How to create a quick formula without adding each line(to skip some line)...example..b3+b4+b5+b7+b8...? thank you
but I do not want to add B6?
=SUM(B3:B8)-B6
=SUM(B3:B5,B7:B8)- thank you! also why to I get (#VALUE!) and not the sum??
- no...another sum (F21:F27)???
- That is a different question.
One or more of the cells contain a #VALUE! error.
- With both formulas?