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 Thursday, October 27, 2022 - 04:45

=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.