sumif function

M

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
 
M

matmich

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

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
_ _
^¢¯^
--
 
Top