a sum formula from b2 to J2

By Ramy, 8 October, 2022

Forum
macOS and Mac Apps

Hello all:
I know how to make a sum formla from let's say b2 to b100,
but can not create a formula from let's say b2 to i2,
how can i type it?

thanks in advance

Options

Comments

By Kevin Shaw on Sunday, October 30, 2022 - 23:12

=SUM(B2:I2)

Note there is a colon between the cell values. This will sum across the row.
Also, cell coordinates are in parens next to the word SUM.