sumif function

[matmich]

i have 2columns
A1 a2
a 8
b 5
a 3
c 2
c 1
I am trying to sum the a2 col if a1 =a,b, or c
I was using sumif but not getting the right answer, is this the righ
function?? if so whats the format of the formul

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100={"a","b","c"}),B1:B100)

 

[matmich]

Frank I tried that with no success, does the dashes after "sumproduct
suppose to mean something?

 

[Frank Kabel]

Hi
yes. Just leave them

 

[Soo Cheon Jheong]

Hi try:

=SUMPRODUCT((A1:A100={"a","b","c"})*B1:B100)

or

=SUMPRODUCT(SUMIF(A1:A100,{"a","b","c"},B1:B100))


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--