+ Reply to Thread
Results 1 to 2 of 2

Splitting total sum into multiple different %

  1. #1
    Registered User
    Join Date
    01-09-2014
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Splitting total sum into multiple different %

    Hi,

    I am completely new to excel but I was wondering if there was a way to split a total sum by entering it into a column into many different sums.

    I would like to add a total amount of $ per fortnight into our offset account but I would like that total amount to be allocated to different things- ie: Holiday money, pets money, household maintenance money etc.

    I have no idea how to set this out and preferably would like to follow an online tutorial on it but don't even know what to type into a search bar?

    any help of tips appreciated.

    Regards,

    Kristin

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,730

    Re: Splitting total sum into multiple different %

    Take a look at using SUMIFS for this.

    When all else fails, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    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

+ 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. Splitting a total sum into multiple boxes!
    By drasston369 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2016, 08:47 PM
  2. Which formula for splitting the total cost between departments?
    By grandpacool in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2015, 12:26 PM
  3. Replies: 14
    Last Post: 08-20-2014, 05:46 AM
  4. [SOLVED] Splitting a Total Cost into Quarterly dates
    By paulhoskin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2013, 11:09 AM
  5. Splitting multiple entries in single cell into multiple columns
    By David_Mitchell in forum Excel General
    Replies: 12
    Last Post: 01-24-2013, 06:57 AM
  6. Splitting Grand Total column in Pivot
    By paulahoward529 in forum Excel General
    Replies: 5
    Last Post: 04-27-2012, 12:15 PM
  7. Replies: 7
    Last Post: 08-16-2010, 11:48 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