I'm looking for a formula.

[devinberry1997]

I'm looking for a formula that will take the Sq Ft totals from AQ37-AQ61 on the "Harvest By Blend" tab of this sheet and auto populate it in G11-G380 on the "Turf Summary" tab of this sheet. It needs to populate correctly based on the Date (C-column), Field # (E-column), & the Blend (F-column). Any help is appreciated!

Here is a copy of the sheet with no sensitive information:

Report Sheet Master-24 (Mr. Excel).xls

RI Cut Sheet Cut Date, ,Wednesday,Maine Farm,Total Sq. Ft. Ship Date,Daily Cut Sheet,2000 Dean,Dean, Sq Ft,Dean,Blend,Field,Pal,Dean,Sizes,T-R,Dean,Customer,Location Doug,1,Trip#,1,500,Blue,510A,1 ttf,1137,Driver,2,500,BSC,510A,1 153,Truck,3,500,BOS,510A,1 258,Air,4,500,Penn3,552A,1 D,Field#s...

docs.google.com

 

[myall_blues]

Where are the dates on the blend sheet?

 

[devinberry1997]

Where are the dates on the blend sheet?

Where are the dates on the blend sheet?

The date is in D3 on the "Harvest By Blend" tab of the sheet.