I'm looking for a formula.

[devinberry1997]

Hello! I'm hoping someone will be able to help me find a formula for this spreadsheet. All the details of what I need the formula to do are under the "Sheet1" tab in this spreadsheet. Thanks!

Report Sheet Pallet Count Test 4-9-24.xls

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

docs.google.com

 

[shift-del]

Report Sheet Pallet Count Test 4-9-24.xls
	Z
6	15
Sheet1

Cell Formulas
Range	Formula
Z6	Z6	=SUMIFS(L$6:L$16,$D$6:$D$16,$Y6)

 

[devinberry1997]

Report Sheet Pallet Count Test 4-9-24.xls
	Z
6	15
Sheet1

Cell Formulas
Range	Formula
Z6	Z6	=SUMIFS(L$6:L$16,$D$6:$D$16,$Y6)

This ended up working great. AMAZING! I was scratching my head for hours trying to figure out a formula. Thank you so much! When you get a chance would you mind helping with a formula that populates the cells blank when there's no data in the "Y"-"AT" columns of the "Pallet Count" tab on this sheet?

Here's an updated version:

Report Sheet Master 2024 (In Progress).xls

RI Cut Sheet Cut Date, ,Wednesday,Maine Farm,Total Sq. Ft. Ship Date,Daily Cut Sheet,0 Dean,Dean, Sq Ft,Dean,Blend,Field,Pal,Dean,Sizes,T-R,Dean,Customer,Location Doug,1,Trip#,1 ttf,1137,Driver,2 153,Truck,3 258,Air,4 D,Field#s,5 6 Ryan,7 1136,8 193,9 239,10 R,11 0,0,0 Sq Ft,Blend,Field,Pal,...

docs.google.com

 

[shift-del]

I would use a userdedinged number format: General,General,
And replace the formula with a SUMIFS().

Report Sheet Master 2024 (In Progress).xls
	AL	AM
6	119
7	99
Pallet Count

Cell Formulas
Range	Formula
AL6:AM7	AL6	=SUMIFS(Z$6:Z$95,$Y$6:$Y$95,$AK6)

 

[MPG Radio]

So having a little trouble here..I would like to know how to color the cell above if only both Product ID are entered. it cant be a specfic text as it is just important if something is in there but all cell ranges need to have some value.

This is what I have so far but I can't seem to take into account multiple cells as the condition. so like =NOT(ISBLANK(C4:C5:C6)) etc

 

[Asbestos_Jen]

Try:

=and(not(isblank(C4)),not(isblank(C4)),not(isblank(C4)))

 

[Joe4]

You may be able to use the COUNTBLANK function.

COUNTBLANK(C4:C6)

will count the number of blank cells in the range C4:C6

You could use something like:

=IF(COUNTBLANK(C4:C6)=3,...

to check to see if they are ALL blank.

Likewise, you could use something like:

=IF(COUNTBLANK(C4:C6)=0,...

to check to see if they are ALL are populated.

If used in Conditional Formatting, it would just be:

=COUNTBLANK(C4:C6)=3

or

=COUNTBLANK(C4:C6)=0

respectively.

 

[MPG Radio]

=COUNTBLANK(C4:C6)=0

This is great the count thingy works the way I need it thank you very kindly and Asbestos_Jen is good too, just a tad bit too long for me...

​

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[MPG Radio]

Hello all, not sure how to word this, if I have an Excel start date in one cell and in another cell a number, what future month in the year would this be.

Thank you hope you can help.