Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula help
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 |