Hi Bob Phillips
Thanks a lot. Great answer. You are right, in that the Januar
collection of Invoice totals was blank cell sensitive. To test th
idea, I shortened the "Range 1" size to end of current data and got th
correct January Total, without your adddition. But, I must have a
extended range of blank cells for incoming future invoices that I wan
totalled automatically. Your prefix insert test for blank cells ha
yielded the correct amount for January. I carried the new formul
forward to all the months and altered the open cell length of the Rang
several times which still gave the correct amounts. Is it to
theoretical question to ask *why*? That is, checking for blank cell
seems to be a problem of January alone. It's not the cell locatio
because I substituted February and other months in the January cel
location and got the correct answers for the given mionth. Hmmmmm!!
Thanks again. George

--
George
-----------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...fo&userid=2412
View this thread: http://www.excelforum.com/showthread.php?threadid=37943