Need Help With Rolling Total Formula

[charllie]

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

 

[ExceLoki]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	16
2
3
4
5
6
7					0	2	3	4	5	0	0	0	0	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
A1	A1	=COUNTIF(E7:R7,">0")*4

 

[xlhelp15]

How about this,

=SUMIF(E7:R7,">0",E7:R7)+4

 

[charllie]

Hi ExceLoki

That does exactly what i need. Thank you very much, i really appreciate your time and help.

Thanks

Charllie

 

[charllie]

How about this,

=SUMIF(E7:R7,">0",E7:R7)+4

Hi xlhelp15

Thanks you for the reply and formula. I will give this a try also.

I appreciate your time and help.

Thanks

Charllie

 

[ExceLoki]

Hi ExceLoki

That does exactly what i need. Thank you very much, i really appreciate your time and help.

Thanks

Charllie

happy to help