Running total in a range of cells

[heitres]

Please Login or Register  to view this content.

I Found this formula in another thread. and I was wondering if its possible for this to affect a range of cells that I want.

for instance I need it to go from F7:F20 / G7:G20, and also add exceptions( that the formula doesn't affect that one) to the ones that have the titles. for example F14.

Thank you for your time!

[HaHoBe]

Hi, heitres,

please give this a try:

Please Login or Register  to view this content.

Ciao,
Holger

[heitres]

Thank you Holger , but the running total doesn't seems to work with this formula. any ideas why?

[heitres]

Sorry it works, i had the macros disable.

thank you so much!

[heitres]

Hi again Holger, sorry to keep going on this but I am learning as I go on. I just realize I also need to add other columns to the formula, I tried different things but I really have no idea !

thank you again for your time.

[HaHoBe]

Hi, heitres,

shouldn´t you indicate what "different columns" are concerned where and in which way?

Ciao,
Holger

[heitres]

entry
D6:D100
runing total
E6:E100

entry
H8:H31
runing total
I8:I31

entry
H38:H74
runing total
I35:I74


thanks again for your patience and time.

[HaHoBe]

Hi, heitres,

one way would be to mulitply the bit of code that was presented first:

Please Login or Register  to view this content.

Or shorten this to

Please Login or Register  to view this content.

Ciao,
Holger