validation of three conditions in three columns and then adding up from the 4th

could anyone out there can help me with the following.

I have created an excel worksheet with following columns
Sn name CA/PS LS/SS CA Size Qnty
1 XYZ CA LS XL 2
2 XYZ CA SS L 2
3 XYZ PS LS XXL 2
4 XYZ PS SS M 2

i want to validate 3 columns ie CA/PS LS/SS CA Size
eg if CA/PS=CS and LS/SS=LS and CA Size=XL(all in the
range of rows) then it should sum from the Qnty column

Your help and assitance will be highly appreciated

thanks
tajammul

Hi
try
=SUMPRODUCT((C2:C999="CS")*(D2999="LS")*(E2:E999 ="XL"),F2:F999)
assuming that row 1 is a heading row

--
Regards
Frank Kabel
Frankfurt, Germany

tajammul faheem wrote:
could anyone out there can help me with the following.

I have created an excel worksheet with following columns
Sn name CA/PS LS/SS CA Size Qnty
1 XYZ CA LS XL 2
2 XYZ CA SS L 2
3 XYZ PS LS XXL 2
4 XYZ PS SS M 2

i want to validate 3 columns ie CA/PS LS/SS CA Size
eg if CA/PS=CS and LS/SS=LS and CA Size=XL(all in the
range of rows) then it should sum from the Qnty column

Your help and assitance will be highly appreciated

thanks
tajammul