=IF(L721,F72,0)+SUMIF(L70:L71,"<0",F70:F71)

Just change the L71 and F71 to your final row.

--
__________________________________
HTH

Bob

"Roachy" wrote in message
...
Probabally a really simple question but Im looking to do my IF function in
a
couple of stages firstly to check cell L72 and check if the value is
greater
than 1 bringing back the value in F72 if true.

Then moves onto L71 and adds the value of F71 to the origional numbers
above
(if the value of L71 doesnt = 0) and so on and so on....

=IF(L721,(F72+IF(L71=0,F71)+IF(L70=0,F70)))

Hope this makes sence

Please help