Sumproduct HELP

[Victoria4338]

need help on a sumproduct function.

Tbl setup
main events (by col)
Front (group)
Col C: qty
Col E: size
Number of colors
Col F thru W, 1 thru 18 (col data down)
Back (group)
Col C: qty same as front (no col)
Col E: size
number of colors

Front: Select qty + size + number of colors + (back: qty + size +
number of colors = $

I can get the sumproduct to work for the front color/qty/size, error
out when I add the back group.

Can you tell me what I'm doing wrong....

Thanks so much

 

[Bob Phillips]

and the formula is ... ?

--
HTH

Bob Phillips

"Victoria4338" <[email protected]>
wrote in message
news:[email protected]...

 

[swatsp0p]

I may be missing something here, what do you mean by "front group" an
"back group"?

More info please.

Bruc

 

[Victoria4338]

I may be missing something here, what do you mean by "front group" an
"back group"?

More info please.

Bruce

t-shirt (Front / back)

=SUMPRODUCT(C12:C24=D2)*(D1224=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

 

[Bob Phillips]

Just plug those cells into the formula?

Or are you asking something else?

--
HTH

Bob Phillips

"Victoria4338" <[email protected]>
wrote in message