View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ross Ross is offline
external usenet poster
 
Posts: 152
Default Need formula help

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