Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking for the total of a sum if statement. I am doing this in order to set up a % of subtotal formula.
Sum If Example
Sum(if(Type='T',Quantity))
Like this:
Sum(if(Type='T',Quantity)) /Sum (Total(Quantity))
Hi DanM84306
Your requirement is not clear. Can you attach a sample file with the data to demonstrate your issue.
So that it will help folks to understand the issue and provide efficient solution.
Thank you.