help calculating average days to pay.

[excel_noobie]

Client A & B

Both have customers they pay between COD (0 Days), N20, N30, N45, and N60.

I'm trying to determine how to create a formula that would give me the best weighted average days paid for both parties.

 

[Sam Mathai Chacko]

Try this for Client A

=SUMPRODUCT(B7:F7,{0,20,30,45,60})/SUM(B7:F7)

 

[excel_noobie]

wow!! i like it!