Hi All
Need some help with a formula if that's ok. I cannot seem to get anything to work.
I have a row of with numbers in, lets say rows E7 to R7. In this row will be any number from 0 to 5 (numbers wont be higher than 5).
What i want to do is - for any cell in E7 to R7 that has a number in it greater than 0, i want to add 4 to the rolling total in cell A1. Any cells that are blank then do nothing.
So as an example if cells E7 = 0, F7 = 2 and G7 = 5 then cell A1 would = 8 as a rolling total. If i then changed E7 to 3 then cell A1 would = 12.
All the other cells are blank so nothing would happen.
I would really appreciate it if someone could help me with a formula.
As always, i appreciate your time.
Thanks
Charllie
Need some help with a formula if that's ok. I cannot seem to get anything to work.
I have a row of with numbers in, lets say rows E7 to R7. In this row will be any number from 0 to 5 (numbers wont be higher than 5).
What i want to do is - for any cell in E7 to R7 that has a number in it greater than 0, i want to add 4 to the rolling total in cell A1. Any cells that are blank then do nothing.
So as an example if cells E7 = 0, F7 = 2 and G7 = 5 then cell A1 would = 8 as a rolling total. If i then changed E7 to 3 then cell A1 would = 12.
All the other cells are blank so nothing would happen.
I would really appreciate it if someone could help me with a formula.
As always, i appreciate your time.
Thanks
Charllie