How to add (sum) specific cells

Y

yodochi

If i have a colum E1:E20 with a specific letter in each cell like A,B,C and
colum F,H,J with specific numbers, how can i ADD values that lies with A only
and B only and C only?
thank u...
 
T

Toppers

Try:

=SUMPRODUCT(--(E1:E20="A")*(MOD(COLUMN(F1:J1),2)=MOD(F1,2)),F1:J20)

I assume you want to add data in columns F,H and J when E="A"
 
B

Barb Reinhardt

Try something like this

=SUMPRODUCT(--(E1:E20="C"),(F1:F20))

HTH,
Barb Reinhardt
 
Top