Sumifs different than cells in range with sumproduct?

[Kamolga]

Hi,

I struggle with a sumifs formula:

I have a table with

Users	Type	Amount

then a table with users I want to take into account in my sumif. I named that range rUsers.
So I can find the total amount for all users in rUsers using
=sumproduct(sumifs(amount;Users;rUsers)
Now the issue is that I do not want the types that are in a table where the range is named rType.

If I try =sumproduct(sumifs(amount;Users;rUsers,Type;"<>rType")
or
=sumproduct(sumifs(amount;Users;rUsers)-sumproduct(sumifs(amount;Users;rUsers,Type;rType)

I never got the right result

 

[jasonb75]

Try this , array confirmed with Ctrl Shift Enter

=sum(sumifs(amount;Users;rUsers)-sum(sumifs(amount;Users;rUsers,Type;Transpose(rType))

I think that using sumproduct will give incorrect results.