=SUM(A1:A14) Not =SUM(A1;A14)
---- On Sat, 24 Jun 2023 12:10:33 +0200 <frank.ledb...@sky.com> wrote --- Thanks Martin, moving on I am now having trouble summimg a column of numbers (each being the result of a multiplication). In the formula bar Iwant to type sum(A1;A8) but ~I am trying to chick on the cells A1 etc which puts the cell in the formula but when I hit ; the whole formula is replaced with the colon. Frank On Friday, 23 June 2023 at 18:02:56 BST, Martin Groenescheij <mailto:mar...@groenescheij.com> wrote: Could it be that one ore both Cells is formatted as Text? If you copy values from another source it could be copied as text which you could check in the formula bar, it shows then with a leading apostrophe e.g. ‘123 Simple way to check is to enter =VALUE(B1)*VALUE(C1) ---- On Fri, 23 Jun 2023 18:40:36 +0200 mailto:frank.ledb...@sky.com.INVALID<mailto:frank.ledb...@sky.com.INVALID> wrote ---- Having problem multiplying the values in two cella.I have tried =B1*C1 for example but it doesn't workDisappointed as my attempt at division worked fine on a previous worksheet using for example=A1/B1Please help if you canFrank
