One way:

=SUMPRODUCT(--(MMULT(--(A1:D13="x"),{1;1;1;1})0),E1:E13)

Note that the MMULT function is limited to a range of 5461 rows.

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
Sure would oblige if any of you experts devise a formula to calculate the
sum
of column E of the following table, wherever an "X" is present in any of
the
corresponding cells of Column A, B, C or D (i.e. resulting to 268326):

X Z Y Y 48421
Y W Z Z 60492
X X X X 22073
W X W W 19299
Z Z Y X 34706
Y W Y W 83035
V Z Z V 64431
X W X W 76684
Y Y Z Z 15703
V Z W W 11638
Z X W V 15573
V X Z X 11751
X Y Y X 39819