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