+ Reply to Thread
Results 1 to 10 of 10

How Can I Calculate a Series of Row's Totals?

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    Brampton, ON
    MS-Off Ver
    Excel 2016
    Posts
    135

    Question How Can I Calculate a Series of Row's Totals?

    I do not know how to search for this so I apologize if it has already been answered.

    I have a list of stores and the costs for various items.
    Each store has (usually) more than one row.
    Each store's items are totaled at the end of each line.
    Simple

    What I do not know how to do is total all rows for each store, automatically. Like I said, I don't know how to explain it, so searching for it does not work out well for me. Please see the attached sheet:How to Calculate Store Total.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How Can I Calculate a Series of Row's Totals?

    Try this, copied down...
    =IF(B3=B4,"",SUMIF($B$3:$B$18,B3,$G$3:$G$18))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    Brampton, ON
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: How Can I Calculate a Series of Row's Totals?

    Quote Originally Posted by FDibbins View Post
    Try this, copied down...
    =IF(B3=B4,"",SUMIF($B$3:$B$18,B3,$G$3:$G$18))
    Ooh, that's clever! Thanks!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How Can I Calculate a Series of Row's Totals?

    Glad to help and thanks for the feedback

  5. #5
    Registered User
    Join Date
    05-23-2013
    Location
    Brampton, ON
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: How Can I Calculate a Series of Row's Totals?

    You know what just happened? I was given new parameters!
    New math has been added: =IF(B3=B4,"",SUMIF($B$3:$B$18,B3,$G$3:$G$18))+((c3*0.5)+(45)*4)*1.3

    It works, but I get #VALUE! in the blank cells. Do you know a workaround?

    Thanks!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How Can I Calculate a Series of Row's Totals?

    C3 is text? any text 8 a value will give an error

  7. #7
    Registered User
    Join Date
    05-23-2013
    Location
    Brampton, ON
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: How Can I Calculate a Series of Row's Totals?

    Quote Originally Posted by FDibbins View Post
    C3 is text? any text 8 a value will give an error
    My mistake: D3

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How Can I Calculate a Series of Row's Totals?

    lol ok

    Can you put the extra into the formula in G?
    =SUM(((D3*0.5)+(45*4)*1.3),E3:F3)

  9. #9
    Registered User
    Join Date
    05-23-2013
    Location
    Brampton, ON
    MS-Off Ver
    Excel 2016
    Posts
    135

    Re: How Can I Calculate a Series of Row's Totals?

    Quote Originally Posted by FDibbins View Post
    lol ok
    Can you put the extra into the formula in G?
    =SUM(((D3*0.5)+(45*4)*1.3),E3:F3)
    <FacePalm>
    How did I not see that...

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How Can I Calculate a Series of Row's Totals?

    it happens

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate Totals
    By jimmy1981 in forum Excel General
    Replies: 1
    Last Post: 11-24-2010, 08:24 AM
  2. Formula to calculate totals
    By deb0and in forum Excel General
    Replies: 5
    Last Post: 02-04-2009, 03:26 PM
  3. Returning totals in a series of tables
    By Nick_in_Dubai in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-30-2008, 12:27 AM
  4. Calculate row totals of Yes/No
    By MarkD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2006, 08:50 AM
  5. calculate totals
    By Marilyn in forum Excel General
    Replies: 3
    Last Post: 07-10-2006, 03:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1