G
Guest
Hi, I am trying complete a project where I need to use nested functions. The
scenario is I have 4 amounts that are grades. The lowest grade is dropped,
and the remaining 3 are averaged to give the grade. I have to use the SUM,
MIN and COUNT function within the same cell address to get the answer.
Here is where I'm stuck...
=SUM(B4:E4)-MIN(B4:E4)
I'm not sure how to use the COUNT function to give me a 3 since all 4 cells
will have amounts? Plus how will I get the above to give me an average? ANy
help appreciated so I can sleep.![Smile :) :)](/styles/default/custom/smilies/smile.gif)
scenario is I have 4 amounts that are grades. The lowest grade is dropped,
and the remaining 3 are averaged to give the grade. I have to use the SUM,
MIN and COUNT function within the same cell address to get the answer.
Here is where I'm stuck...
=SUM(B4:E4)-MIN(B4:E4)
I'm not sure how to use the COUNT function to give me a 3 since all 4 cells
will have amounts? Plus how will I get the above to give me an average? ANy
help appreciated so I can sleep.
![Smile :) :)](/styles/default/custom/smilies/smile.gif)