Forum Discussion

Copper Contributor

Jan 15, 2021

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

Formulas and Functions

NikolinoDE

Platinum Contributor

Jan 16, 2021

Yugandhar__Y

As far as I could understand (but that does not mean that this is correct :), these formulas should help you further.

DAVERAGE function

https://support.microsoft.com/en-US/office/dbmittelwert-funktion-a6a2d5ac-4b4b-48cd-a1d8-7b37834e5aee

DMAX function

https://support.microsoft.com/en-us/office/dmax-function-f4e8209d-8958-4c3d-a1ee-6351665d41c2?ui=en-US&rs=en-US&ad=US

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)