Home |
Search |
Today's Posts |
#1
|
|||
|
|||
culmulative calculations
what is formula to produce culmative totals across rows in Excel
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
How do I set up a standard form showing incentive calculations | Excel Discussion (Misc queries) | |||
excel calculations | Excel Worksheet Functions | |||
Calculations too long | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) |