Hi All,

I have a list that has 100 entries with 12 columns. Each column
represents savings for a month. What I am trying to do is find the
first year's savings. So what I need to do is get a count of months
that are blank to get a multiplier value to multiply to a set monthly
savings for each entry. I guess I could do this by just counting.
each line but that could get tedious and this list may grow to over
200 entries each month. Is there a quicker way to do this via a loop
macro?

Also is there a beginners guide to the syntax of loops and macros in
excel?

Thanks,

John