Sum values if criteria is spread across two columns

[Charles33]

Hey,

I have a simple table (list) of 3 columns. Two of them represent different units (let's say different company names) that repeat irregularilly within both columns. The other column lists number of transactions assigned the the unit.
I am trying to write a formula where I'd sum up values within a single column provided that the value "belongs" to a given unit. See example below

Name 1 | Name 2 | Number to be summed up
x | a | 1
y | b | 4
z | x | 7

I'd like the formula to sum values for Name "X". In this case it would be 8.

Hope my explanation is clear, I'd appreciate any indication how to do it. I've tried with SUMIF but most likely it needs to be more complex than that.

Thanks!
Charles

[PaulM100]

This should work: =SUMPRODUCT(($C$6:$D$8="x")*($E$6:$E$8))

[Charles33]

Thanks for quick reply Paul. Tried it but doesn't work for me.

How I understand it:
($C$6:$D$8="x") -> the array with the name of the company
($E$6:$E$8) -> the column with values

Why would you multiply it ? just a thought.

Thanks!

[Charles33]

Worked eventually ! Thank you.

[PaulM100]

($C$6:$D$8="x")*($E$6:$E$8))
$C$6:$D$8 - columns of companies
$E$6:$E$8 - column to sum
X - the company you are looking for
($C$6:$D$8="x") - this will return an array of true and false
doing the multiplication will coerce the true and false to 1 and 0, and will multiply the result with the values returned from summing column(Eg in this case(1*1+1*7)