Hi Oldham,
I'm still a bit green on excel but I just added the if Function below and it looks for the first blank cell (NO DATA), probably a bit crude but it worked.
=IF(A1="",SUM IF TRUE,SUM IF FALSE)
Just put in the formula you use for Sum if true / false.
Plater
The minute you start talking about what you're going to do if you lose, you have lost.
Got to update this when I have time please be patient ,thank you ,Open Forum...Total Lays......?Total Backs....?Hidden Forum Total Backs....?Total Lays......?