Ask Your Question
0

how do I add numbers in certain cells of a spreadsheet

asked 2021-04-11 22:33:25 +0200

davidbear gravatar image

Select the sigma, select sum, in the formula bar I enter SUM(C8:C17:C26) - these are the cell locations of the spreadsheet. The results are wrong. Cell C8 has a figure of 486357.00. Cell C17 has a figure of 194195.82 and cell C26 has a figure of 612.52. The sum of these figure should be 671165.34. The above formula returns 875336.16.

edit retag flag offensive close merge delete

Comments

The above formula returns 875336.16

The above Formula =SUM(C8:C17:C26)automatically changes to =SUM(C8:C26) and adds all values between C8 and C26 (Take care when using a range definition with more than one ":" separator, because you'll end up in a max range defined by the cell addresses)

Opaque gravatar imageOpaque ( 2021-04-12 12:10:27 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2021-04-11 22:50:23 +0200

keme gravatar image

Use semicolons to address individual cells:

=SUM(C8;C17;C26)

(Commas may also work, depending on what you use for decimal separator.)

Cell addresses separated by colon specifies a range (from:to), which would sum the specified cells and all cells in between.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-04-11 22:33:25 +0200

Seen: 23 times

Last updated: Apr 11