I have data in 5 different columns, of which Column 'A', 'B' and 'C' contains
text and Column 'D' and 'E' contains numbers. Could you please tell me a
formula through which i can add the numbers in column 'E' if Column 'A', 'B',
'C' and D has the the required data.

I tried with an array formula
{=SUM(IF((A$2:A$9999="XX")*(B$2:B$9999="XY")*(C$2: C$9999="yy")*(D$2:D$9999="11"),E$2:E$9999))}

A B C D E
xx xy yy 11 123



--
Karthi