Please disregard the zero part.

Yeah, that had me confused!

Ok, try this in B14:

=IF(COUNT(B1:B12),LOOKUP(1E100,B1:B12),"")

--
Biff
Microsoft Excel MVP


"Ross" wrote in message
...
Sorry folks. Please disregard the zero part. I was thinking about
another
part of the spreadsheet.

Thanks

--
smither fan


"Ross" wrote:

Hi all
I have a worksheet with A1:A12 as Jan thru Dec and B1:B12 as monthly
totals.
I would like to put a formula in B14 that would reflect the new months
total
as I input it. In other words, it would show January's total until I
input
February's, and so forth? Also, It should show a zero in the months that
I
don't input anything into. Can I do such a thing?

Many thanks, and I do leave feedback, as I hope others do...
--
smither fan