Fixed running total

[bizmark222]

Hi
I know how to total sum cells together but-
I need for example, if f5,f6,f7 = 1 (f5 has 1 in it) and i change the value in f5 back to 0 the sum total stay fixed at 1, so if f6 was to show 3 it would =4 and keep an ongoing total regardless of numbers changing back to 0 in above cells, make sense?

 

[Fluff]

For me it only adds the numbers in F5:F7 (as originally requested)
If it works for you until you link it to some other software, it maybe the other software is causing the problems.

 

[bizmark222]

Yes, absolutely, thank you again.
Just needed confirmation that there was no way around it.
Thanks anyway