Hi all,
Please Help!!!
I'm really struggling to create possibly a basic formula....
I need to create a simple sumproduct with multiple arrays.
Column A = Model
Column B = Country
Column C = Price
Column D = Inventory
I need to calculate the Value of both Positive and Negative Inventory seperately
I used to have a simple Sumproduct(if.. formula and only had inventory shown once per model.
However, i've since populated the inventory column so that a figure is shown against all models whenever filtered against.
Arrays
a) Column B = "Total"
b) Column D >0
Calc:
Column C x Column D
Can anyone help? It's driving me nuts!!!
Thanks
Jeffuzz.


LinkBack URL
About LinkBacks
Reply With Quote
in there, but it's been a while since I've had to write these so I'm a little bit rusty.

