Forum Discussion

brunemboutlookcom

Copper Contributor

Mar 31, 2022

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

Formulas and Functions

Iron Contributor

Mar 31, 2022

brunemboutlookcom

Try:

=SUM(B3:B8)

This will sum all cells between B3 and B8.

brunemboutlookcom

Copper Contributor

Mar 31, 2022

but I do not want to add B6?

Detlef_Lewin
Silver Contributor
Mar 31, 2022
brunemboutlookcom
=SUM(B3:B8)-B6 =SUM(B3:B5,B7:B8)
- brunemboutlookcom
  Copper Contributor
  Mar 31, 2022
  thank you! also why to I get (#VALUE!) and not the sum??
  - brunemboutlookcom
    Copper Contributor
    Mar 31, 2022
    no...another sum (F21:F27)???

Resources