1. ## Calculating Gross Totals - Business

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.

2. ## Re: Calculating Gross Totals - Business

With this resource ( https://www.extendoffice.com/documen...-then-sum.html ) , the function SUMPRODUCT appears to do what's needed. (Refer to "Multiply two columns and then sum without criteria" section, which illustrates your scenario)

For example, if Type is Column A header, Price is Column B header, and Count is Column C header, then we could write in a cell =SUMPRODUCT(B2:B5,C2:C5)

3. ## Re: Calculating Gross Totals - Business

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.

Or you could simply set up a table where Column A is Type, Column B is Price, Column C is count, Column D is (Column B times Column C = B2*C2 and copy down). Then sum Column D and that will be what you want.

4. ## Re: Calculating Gross Totals - Business

Thank you very much, that sumproduct was exactly what I was looking for.

5. ## Re: Calculating Gross Totals - Business

So second question, how do i change this thread to show its been solved?

6. ## Re: Calculating Gross Totals - Business

No need to do that: just buy us a drink

7. ## Re: Calculating Gross Totals - Business

Originally Posted by DenisB
No need to do that: just buy us a drink
Your contribution to this thread Denis the Menace is not even worthy of a single ice cube!

8. ## Re: Calculating Gross Totals - Business

Why waste a good drink with ice cubes?!