Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula question
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Geauxfish" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Question about this formula... | Excel Worksheet Functions | |||
Formula question | Excel Discussion (Misc queries) | |||
If/Then Formula Question | Excel Discussion (Misc queries) |