Sum if with a list as criteria

M

Matizka

Hi,

I need to sum all of the values for columns that are called: :A, B, C,
D.

I would like to use something like "in list " operand that are in some
othe programs. How should I write it?

Sorry if it is an obvious or recently asked questions I did some search
on the forum but I haven't found an answer.

Thanks in advance,

M.
 
P

Peo Sjoblom

Here's one way

=SUM((A1:A20=TRANSPOSE(MyList))*(B1:B20))

with the list called MyList, needs to be entered with ctrl + shift & enter



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
M

Matizka

Hi,

I did the above but my result is equal to the value of first column
meeting the condition.

It does not add the other values from the other columns.

Do you have an idea what can be not correct/

Or how differently it can be done

Thanks,

M.

By the way I have learnt today much about array functions :)
 
Top