It's not an array, and it's not pretty...

...but it works.

=IF(ISBLANK(B5),0,MAX($B$2:$B$5)-B5+1)+IF(ISBLANK(C5),0,MAX($C$2:$C$5)-C5+1)+IF(ISBLANK(D5),0,MAX($D$2:$D$5)-D5+1)+IF(ISBLANK(E5),0,MAX($E$2:$E$5)-E5+1)


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=538680