SUMING two columns

Hello Excel masters,

I have a question that might be stupid but i cant find an easy solution.
To present the problem i will help myself with this table:

23	2		13
34	2		12
12	2		11
12	2		14
13	2		15
15	2		16
16	2
14	2
22	2
13	2

is there any way to do equation in one cell which would sum all the values in column 2 where values from column 4 (last) (whole column - the array) are equal to values in column 1. In this upper case the sum would be 14. one way is to transpose the column 4 then it would work but i dont want to solve it this way :D

thanx for help

That would be fine , but i want to do that equation in one cell,
since my problem is a little bit more complicated than that shown in the post. And i want to know if that kind of SUM is even possible.

thanx for fast replays

FDibbins i dont think we understood each other correctly it dosent need to be the same cell where there is an entry already, to put thing in perspective i dont have values in column D(as shown in table), i have an array of values(which i receive from another formula) that is formed as a column, and i cannot add extra columns for an array What bugs me is that if array would be formed as a row the thing would work, but since its comparing two columns excel fails to recognize which values are the same since it only cheks the first row in column D and ignores the rest.

i hope it more understandable now?

haha Tony thanks so easy at the end, i will try this one, that is what i had in mind yap i tried gazilion of combination with sumproduct but somehow was convinced that it wont work with sumif :D

Originally Posted by Tony Valko

Another way using SUMPRODUCT:

=SUMPRODUCT(--ISNUMBER(MATCH(A1:A10,C1:C6,0)),B1:B10)

I like the SUMPRODUCT(SUMIF version better. Less typing!

it would also work just with SUM and fancy brackets {} {=SUM(ISNUMBER(MATCH(A1:A10,C1:C6,0))*B1:B10)}, but sumif is the most elegant way i agree. Thanks again this opens many new options for me the next time i will need to calculate something :D

Thanks works like a charm