Excel formula

I need a formula for;
(Cooling meter/Sum of cooling meters)* Sum of electricity meters

I tried =SUM(C2:AX32/$C$2:$AX$125)*$C$126:$AX$187
but I am getting a #VALUE error

By: Christina

Leave a Reply

Your email address will not be published. Required fields are marked *