I have a set of raw data that's huge. 4 columns are relevant for my
question: Quantity, Category, Style, Size. I need a formula that
tells me the following:

Look for Category X and Style Y and Size Z. Give the sum of all
occurences in the Quantity column where X, Y and Z occur
simultaneously.

Is this possible? Thanks in advance for help!


--
jn77
------------------------------------------------------------------------
jn77's Profile: http://www.excelforum.com/member.php...o&userid=36547
View this thread: http://www.excelforum.com/showthread...hreadid=563019