Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing columns
I'm ashamed to say that although I passed City & Guilds a few years ago
I've forgotten almost everything I know about this program. if I have a column of numbers say cells A1- 500, how can I put the running total in B1, B2, etc? Also, when there is a negative balance this comes up red, can I change this to black? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing columns
In B1 put
=SUM($A$1:A1) copy down Use a format of £#,##0.00 will return negative with a preceding minus -- Regards, Peo Sjoblom "thedarkman" wrote in message ups.com... I'm ashamed to say that although I passed City & Guilds a few years ago I've forgotten almost everything I know about this program. if I have a column of numbers say cells A1- 500, how can I put the running total in B1, B2, etc? Also, when there is a negative balance this comes up red, can I change this to black? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing a variable range of columns | Excel Worksheet Functions | |||
Summing Columns | Excel Worksheet Functions | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |