Forum Discussion
Solved
Sum up customer specific costs from another table
Hey there, I'm having trouble summing up customer specific costs from another table. I have a table with loads of columns, the revelent ones are: Order ID, Customer ID and Cost There can be ...
That worked like a charm, thank you very much.
Is it possible to modify the SUMPRODUCT to something like SUM(PRODUCT()), so that part of it returns an array? Sadly thats necessary for my assignment.
Is it possible to modify the SUMPRODUCT to something like SUM(PRODUCT()), so that part of it returns an array? Sadly thats necessary for my assignment.
You can enter formula
=(A2=Tabelle36!K2:K15)*Tabelle36!U2:U15
in your excel file to retrieve an array returning value for the selected product as shown in attachment Sumproductarray.