How to add (sum) specific cells
Try something like this
=SUMPRODUCT(--(E1:E20="C"),(F1:F20))
HTH,
Barb Reinhardt
"yodochi" wrote:
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...
|