View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default CONDITIONAL SUM ("OR")

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