jn77 wrote:
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

Hi,

Maybe you can use SUMPRODUCT(). Something like:

=SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"),--(C1:C100="Z"),D1:D100)

Where Category is in Column A, Style in B, Size in Z and Quantity in D.


Regards,
Bondi