culmulative calculations
what is formula to produce culmative totals across rows in Excel
|
Tough to provide without an example.
******************* ~Anne Troy www.OfficeArticles.com "Centurian" wrote in message ... what is formula to produce culmative totals across rows in Excel |
"Centurian" wrote: what is formula to produce culmative totals across rows in Excel Example ................ Ist row of data in Excel s/s is no of units rented monthly what formula can I put in 2nd row to calculate culmative rental income e.g Row No 4, Col 1= 10 col 2 = 12 col 3 = 20 2nd row formula maually Col 1 = b4*25, Col 2 b4+c4*25, Col 3 b4+c4+d4*25 etc. That's a log way of doing it, is there a short cut? Thanks Anne |
Hi!
Try this: =SUM($B4:B4)*25 Drag copy across as needed. Biff "Centurian" wrote in message ... "Centurian" wrote: what is formula to produce culmative totals across rows in Excel Example ................ Ist row of data in Excel s/s is no of units rented monthly what formula can I put in 2nd row to calculate culmative rental income e.g Row No 4, Col 1= 10 col 2 = 12 col 3 = 20 2nd row formula maually Col 1 = b4*25, Col 2 b4+c4*25, Col 3 b4+c4+d4*25 etc. That's a log way of doing it, is there a short cut? Thanks Anne |
Thanks Biff but I regret it did not solve the prob. Resigned to doing long way
Centurian "Biff" wrote: Hi! Try this: =SUM($B4:B4)*25 Drag copy across as needed. Biff "Centurian" wrote in message ... "Centurian" wrote: what is formula to produce culmative totals across rows in Excel Example ................ Ist row of data in Excel s/s is no of units rented monthly what formula can I put in 2nd row to calculate culmative rental income e.g Row No 4, Col 1= 10 col 2 = 12 col 3 = 20 2nd row formula maually Col 1 = b4*25, Col 2 b4+c4*25, Col 3 b4+c4+d4*25 etc. That's a log way of doing it, is there a short cut? Thanks Anne |
All times are GMT +1. The time now is 02:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com