Just plug those cells into the formula?
Or are you asking something else?
--
HTH
Bob Phillips
"Victoria4338"
wrote in message
news:Victoria4338.1rgjmn_1120165623.7185@excelforu m-nospam.com...
swatsp0p Wrote:
I may be missing something here, what do you mean by "front group" and
"back group"?
More info please.
Bruce
t-shirt (Front / back)
=SUMPRODUCT(C12:C24=D2)*(D12:D24=E2)*(F11:W24=F2)
for example in cell D2 I enter the qty
E2 enter Size,
I need to look across Col F - W Color 1, 2, etc....
This needs to be done for the back
qty would be the same
buy the size could change
and the number of colors used.
--
Victoria4338
------------------------------------------------------------------------
Victoria4338's Profile:
http://www.excelforum.com/member.php...o&userid=24806
View this thread: http://www.excelforum.com/showthread...hreadid=383642