Ravi Sir's Cards › Excel
Dairy Milk Collection System in Excel (card 2 of 2)
Revision card 2 for Dairy Milk Collection System in Excel: Litres on the day: =SUMIFS(Collection!$E$5:$E$3000,Collection!$A$5:$A$3000,A5) gives 79.5; Average fat for the period: =SUMPRODUCT(Bill!C5:C12,Bill!D5:D12)/Bill!C13 gives 5.06; Top farmer by litres: =INDEX(Bill!B5:B12,MATCH(MAX(Bill!C5:C12),Bill!C5:C12,0)) gives Salman Shaikh. Includes an example data table.
Read card text
What this card says
2 for Dairy Milk Collection System in Excel: Litres on the day: =SUMIFS(Collection!$E$5:$E$3000,Collection!$A$5:$A$3000,A5) gives 79.5
Average fat for the period: =SUMPRODUCT(Bill!C5:C12,Bill!D5:D12)/Bill!C13 gives 5.06
Top farmer by litres: =INDEX(Bill!B5:B12,MATCH(MAX(Bill!C5:C12),Bill!C5:C12,0)) gives Salman Shaikh. Includes an
Example
data table
Learn this in the lesson: Dairy Milk Collection System in Excel: Fat and SNF Rate Chart, Shift Entries, Farmer Bills and Dashboard