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 |
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 |
All times are GMT +1. The time now is 07:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com