Ravi Sir's Cards › Excel
Farm Management System in Excel (card 2 of 2)
Revision card 2 for Farm Management System in Excel: Yield per acre: =F5/C5 gives 8.8; Net sale: =F5-G5-H5 gives ₹34,812; Cost per plot: =SUMIFS(Expenses!$E$5:$E$3000,Expenses!$B$5:$B$3000,A5) gives ₹56,700.
Read card text
What this card says
2 for Farm Management System in Excel: Yield per acre: =F5/C5 gives 8.8
Net sale: =F5-G5-H5 gives ₹34,812
Cost per plot: =SUMIFS(Expenses!$E$5:$E$3000,Expenses!$B$5:$B$3000,A5) gives ₹56,700.
Learn this in the lesson: Farm Management System in Excel: Plot-wise Expenses, Crop Sales, Profit per Acre, Cost per Quintal and Dashboard