How to add (sum) specific cells

[Guest]

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...

 

[Guest]

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"

 

[Guest]

Try something like this

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

HTH,
Barb Reinhardt