| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104234 | 2009-10-21 04:34:00 | Excel formula | Myth (110) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 822628 | 2009-10-21 04:34:00 | Is it possible to add the total of 2 tables e.g. add the total of A10:A13 and C10:C13 together so that if each cell had a value of 1, I should get a total of 8 (1+1+1+1+1+1+1+1) I have a table which I have split into 4 colums, 2 of those columns contain similar numeric values that I need to be totalled in another cell I hope this makes sense lol |
Myth (110) | ||
| 822629 | 2009-10-21 04:45:00 | Is this what you're after =SUM(A10:A13,C10:C13) |
TeejayR (4271) | ||
| 822630 | 2009-10-21 05:00:00 | Is this what you're after =SUM(A10:A13,C10:C13)Close The answer I just discovered is =SUM(A10:A13;C10:C13) Its for OO Calc, but I figured Excel would be the same, Discovered its not quite lol Ty :) |
Myth (110) | ||
| 1 | |||||