Looking for a formula. I feel like I'm close.

[devinberry1997]

Under the "Harvest By Blend" tab I'm looking for a formula that will auto populate the Sq Ft from (J6-J129) into the "Maine Farm Square Foot .... By Blend" table (O5-AL5 - O8-AL28) based on a few things: the Blend name (E6-E129) (Blue, BOS, BSC, BF, Penn3, etc.) and the Field (F6-F129) that it was taken from. Any help is appreciated! Screenshot is the current formula I have that isn't working. Link attached is for the spreadsheet with no sensitive information.

Test Sheet Master 2024.xls

RI Cut Sheet Cut Date,3/26/24,Tuesday, ,Wednesday,Maine Farm,Total Sq. Ft. Ship Date,2/27/24,Wednesday,Daily Cut Sheet,10600 Dean,Dean, Sq Ft,Dean,Blend,Field,Pal,Dean,Sizes,T-R,Dean,Customer,Location Doug,1,Trip#,1,64,alberts,2000,alberts,BF,517B,4,alberts,4 x 5,alberts,Wedgewood Pines,Stow, MA

docs.google.com

EDIT:
Oh shoot! I forgot to mention it's done by load. There are sperate load tables.

 

[rilzniak]

Cell Q6/Q7/Z6/Z7:

=SUMIFS($J$6:$J$16,$E$6:$E$16,P$5,$F$6:$F$16,$P6)

Is that what you're looking for?

 

[devinberry1997]

Cell Q6/Q7/Z6/Z7:

=SUMIFS($J$6:$J$16,$E$6:$E$16,P$5,$F$6:$F$16,$P6)

Is that what you're looking for?

That's the general idea! It's close, however its currently only working for the first blend of the first load (P6-Q6-P7-Q7) Thanks for your help!

 

[rilzniak]

That's the general idea! It's close, however its currently only working for the first blend of the first load (P6-Q6-P7-Q7) Thanks for your help!

Just modify the end range (16) to the row you'd like to ensure all data can be captured.

I tested the formula and it was working for other blends (Z6/Z7).

 

[devinberry1997]

Just modify the end range (16) to the row you'd like to ensure all data can be captured.

I tested the formula and it was working for other blends (Z6/Z7).

Ah yes, I see now. It works great! Thank you for your help!!!