jn77

=SUMPRODUCT(--((Category rng)=X),--((Style rng)=Y),--((Size rng)=Z),Quantity
rng)

replace rng with your range. Note all 4 ranges must be the same size.

Dave

"jn77" wrote in message
...

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