| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
