Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Sums
Resolved · Low Priority · Version Standard
Ian has attended:
Excel Introduction course
How do i add figures up and get a final total at the end of a spread sheet ?
Hi Ian,
SUM is the function to add a list of figures in Excel.
=SUM(cell 1: last cell)
e.g. if the list is over 3 columns from cell A1 to C10 and the result will show in cell A11. Then in cell A11, you may type:
=sum(A1:C10)
Hope this helps.
Regards,
Katie
|
Excel tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |
We'll call during UK business hours
Server loaded in 0.1 secs.