Hi,
I struggle with a sumifs formula:
I have a table with
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
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