Darlene,
>There must be a macro that can do most of this quickly as opposed to the
>=sum(c5+c6+c7)/(b5+b6+b7) that I'm using for the 12 month moving totals.
That seems simple enough to me. In fact =(c5+c6+c7)/(b5+b6+b7) would be
OK - the sum function is redundant. Or =sum(c5:c7)/sum(b5:b7).
If anything, the total for the calendar year seems more complex. What
are you doing for that?
>If I copy it, it drops the last row.
That's puzzling. What exactly do you mean? It works fine in a
spreadsheet I tried.
Joe
>
>
-----
**Need help with PCSOFT mailing list? Send an Email to:**
Bob Wright<[log in to unmask]> or Drew Dunn<[log in to unmask]>
|