FARAZ ,thanks for your feedback..
--
If this post helps click Yes
---------------
Jacob Skaria


"FARAZ QURESHI" wrote:

Man that's great Jacob!

Never had the idea of using "" for neglecting double counting!

XClent.

"Jacob Skaria" wrote:

Try this...

=SUMPRODUCT(--((A1:A25="X")+(B1:B25="X")+(C1:C25="X")+(D1:D25="X ")0),--E1:E25)

If this post helps click Yes
---------------
Jacob Skaria


"FARAZ QURESHI" wrote:

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