I'm putting together a spreadsheet for tracking how much grain gets put into each bin. And so I made a simple table that looks something like this:
Each load gets classified with its origin, date, moisture and weight.
But I was wonder how I can pull the figures from those tables into another table that sorts the loads by the Field name. So if I mix several Fields across several different bins I have one place I can instantly look up how much yield was accumulated off each field. Right now the only way would be to manually look up and add each load. Any ideas on how I can do this? I need to make some kind of function that searches for the Field name and accumulates results. I am entering the loads with my Ipad mounted in the combine while we harvest. |