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
7 Replies
- but I do not want to add B6?
=SUM(B3:B8)-B6 =SUM(B3:B5,B7:B8)
How to create a quick formula without adding each line(to skip some line)...example..b3+b4+b5+b7+b8...? thank you
=SUM(B3:B8)-B6
=SUM(B3:B5,B7:B8)