How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1
I am trying to create a formula that will
Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value.
There may be an easier or more straight forward way to do this but I am not sure.
Below is an example of what I am trying to achieve. Please forgive the use of Excel to quickly show what I am trying to achieve.
Here to learn, willing to help!
Help Article Resources
Check out the Formula Handbook template!