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...
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.)