Originally Posted by

**SilverDollar** Hello there, to give some context, I'm a business owner who sells concessions like food and drinks. I'm using Excel to help me track my sales and gross. What I'm trying to do is find an equation that will allow me to find my Gross Total from my Sum Price and Sum Count.

To give an example:

Type: Drink 1 Drink 2 Drink 3 Drink 4

Price: 4 2 1 3

Count: 6 8 3 7

So in this example, SumPrice is $10 and SumCount is 24, and if I was to do the math the GrossTotal is $64

The problem is that writing out Drink1Price * Drink1Count + Drink2Price * Drink2Count + ...etc. is long and tedious. Excel makes it easy to add the sum, so I'm hoping someone here is able to help me out.

What I've tried doing is PriceSum * CountSum / TypeCount , but it game me the wrong answer.

So, If there is someone who knows how I could go about this, I would love to hear the answer.