Thread: Sumproduct HELP
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

and the formula is ... ?

--
HTH

Bob Phillips

"Victoria4338"
wrote in message
news:Victoria4338.1rgbat_1120155353.5452@excelforu m-nospam.com...

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


--
Victoria4338
------------------------------------------------------------------------
Victoria4338's Profile:

http://www.excelforum.com/member.php...o&userid=24806
View this thread: http://www.excelforum.com/showthread...hreadid=383642