Results 1 to 8 of 8
Like Tree2Thanks
  • 1 Post By MacstersUndead
  • 1 Post By Debsta

Thread: Calculating Gross Totals - Business

  1. #1
    Newbie
    Joined
    Oct 2018
    From
    Oklahoma
    Posts
    4

    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.

    So, If there is someone who knows how I could go about this, I would love to hear the answer.
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Senior Member
    Joined
    Jan 2009
    Posts
    399
    Thanks
    68

    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)
    Thanks from SilverDollar
    Follow Math Help Forum on Facebook and Google+

  3. #3
    MHF Contributor
    Joined
    Oct 2009
    From
    Brisbane
    Posts
    1,073
    Thanks
    317

    Re: Calculating Gross Totals - Business

    Quote Originally Posted by SilverDollar View Post
    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.
    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.
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Newbie
    Joined
    Oct 2018
    From
    Oklahoma
    Posts
    4

    Re: Calculating Gross Totals - Business

    Thank you very much, that sumproduct was exactly what I was looking for.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Oct 2018
    From
    Oklahoma
    Posts
    4

    Re: Calculating Gross Totals - Business

    So second question, how do i change this thread to show its been solved?
    Follow Math Help Forum on Facebook and Google+

  6. #6
    MHF Contributor
    Joined
    Feb 2015
    From
    Ottawa Ontario
    Posts
    2,069
    Thanks
    412

    Re: Calculating Gross Totals - Business

    No need to do that: just buy us a drink
    Follow Math Help Forum on Facebook and Google+

  7. #7
    MHF Contributor
    Joined
    Oct 2009
    From
    Brisbane
    Posts
    1,073
    Thanks
    317

    Re: Calculating Gross Totals - Business

    Quote Originally Posted by DenisB View Post
    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!
    Thanks from DenisB
    Follow Math Help Forum on Facebook and Google+

  8. #8
    MHF Contributor
    Joined
    Feb 2015
    From
    Ottawa Ontario
    Posts
    2,069
    Thanks
    412

    Re: Calculating Gross Totals - Business

    Why waste a good drink with ice cubes?!
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 3
    Last Post: Oct 19th 2014, 12:23 PM
  2. Averaging out totals for the end of a month
    Posted in the Statistics Forum
    Replies: 1
    Last Post: Apr 1st 2013, 12:17 PM
  3. Replies: 9
    Last Post: Sep 11th 2011, 05:18 AM
  4. Sum of a series, totals of decreasing bets
    Posted in the Math Topics Forum
    Replies: 0
    Last Post: Feb 19th 2011, 07:39 PM

Search Tags


/mathhelpforum @mathhelpforum