Z
zy1972
Hi, I have the following schedule. Basicall, I would like to drive my YTD
average customer calculation by input month.
Is there a simple formula to achieve that?
for example, if you input June, YTD average cust automated calculated as 4.72
YTD average cust is calculated as:
(Jan consump+Feb consump+...)/(Jan consump/Jan cust+Feb consump/Feb cust...)
Input month June
Jan Feb Mar Apr May YTD
consump 20.00 30.00 40.00 60.00 50.00 200.00
cust 2.00 4.00 5.00 7.00 6.00
cons/cust 10.00 7.50 8.00 8.57 8.33 42.40
YTD Average cust 4.72
average customer calculation by input month.
Is there a simple formula to achieve that?
for example, if you input June, YTD average cust automated calculated as 4.72
YTD average cust is calculated as:
(Jan consump+Feb consump+...)/(Jan consump/Jan cust+Feb consump/Feb cust...)
Input month June
Jan Feb Mar Apr May YTD
consump 20.00 30.00 40.00 60.00 50.00 200.00
cust 2.00 4.00 5.00 7.00 6.00
cons/cust 10.00 7.50 8.00 8.57 8.33 42.40
YTD Average cust 4.72