Forum Discussion
Formula for Average Yield
Please help with the formula:
Col A: Farmer Name
COl B: Area in Acres
Col C: Yield estimate in total
Col 😧 Yield Estimate per Acre
Col E: Actual Yield
Col F: Actual Yield / Ac
Col G: Difference%
The Yield Estimate is given for all areas & farmers..but actual yield is entered after harvest.
Please suggest with a formula to calculate the Average Yield when the data is entered in Col E.
i.e; the total area harvested has to be calculated...( area harvested is considered when the data is entered in the Col E.)
3 Replies
Simple AVERAGE() ignores blank cells, but it returns an error if ALL cells are blank, You may handle that using IFERROR(), thus average pert farmer could be like
=IFERROR(AVERAGE(E3:E10),"")If you need average per acre for all farmers and/or other stats it's better to know on which version of Excel you are (365, 2016, Online, etc.)
- Did you want to work out Average Yield per Acre, ignoring acres where there is not actual yield?
As far as I could understand (but that does not mean that this is correct :), these formulas should help you further.
DAVERAGE function
DMAX function
I would be happy to know if I could help.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
