Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumproduct HELP
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
I may be missing something here, what do you mean by "front group" and "back group"? More info please. Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=383642 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |