formula question

G

Geauxfish

Can someone help me out with this problem. Don't understand the syntax or
where to find out what the symbols mean.
Below I have information w/ formula following. The titles are in columns
and numbers are below on spreadsheet shown in "_". I need to figure the
formula for "Average Cost per cycle".
"J" A Miles=0, "K" Number of cycles=0, "L"Cost per cycle=$0.00 (=J16*AA16)
"M" B Miles=7.204, "N" Number of cycles=4, "O" Cost per cycles=$1,801.00
(=M16*AB16)
"P" C Miles=1.356, "Q" Number of cycles=4, "R" Cost per cycle=$678.00
(=P16*AC16)
"S" Average Cost Per Cycle (trying to figure)
"T" Total Cost Per Cycle=$2,479.00 (=SUM(V16)/LARGE(X16:Z16,1))
"U" Total Miles=8.560 (=SUM(J16,M16,P16))
"V" Total Mowing Cost=$9,916.00
(=SUM((J16*AA16)*K16,(M16*AB16)*N16,(P16*AC16)*Q16))
These are rates used to give me my cycle costs...they stay same.
"AA" Cost per cycle/mile for A=$875.00
"AB" Cost per cycle/mile for B=$250.00
"AC" Cost per cycle/mile for C=$500.00
 
L

Luke M

Since you calculate total cost in V, you can use:
=V16/SUM(K16,N16,Q16)

(value is $1,239.50)

to calculate average cost per cycle.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top