The above formula does not work if there are blank cells in between and
it will not work once you go pass Column Z (ie. Column AA)

I have not been able to come up with something that will suit your
application without filling the blank cell with 0. I bet vba can help
you tho.



Phillycheese5 Wrote:
The formula works for some cells but not others...it seems to be pulling
the last column in some cases and the second to last in others. Does it
matter if I have text in any of the cells to the far left (like in A and
B), and then sporadic blank cells?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388139