+ Reply to Thread
Results 1 to 6 of 6

Would an array formula be useful to find the total?

  1. #1
    Registered User
    Join Date
    08-08-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    30

    Would an array formula be useful to find the total?

    Hello there,

    I hope you can understand from this explanation.

    Imagine B2 to M2 to contain monthly figures in terms of hours to be spent on a section of a project, N2 to include the total money coming in for that project.

    I'd like to find the incidence of the hours over the total, obtaining how much is worth a given month.
    This was solved by doing N2*Given Month/(SUM(B2:M2)).

    Prospects Jan-16 Feb-16 Mar-16 Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Money coming in
    Test 0.00 0.00 0.00 0.00 228.75 228.75 228.75 228.75 0.00 0.00 0.00 0.00 £27,280.00

    Total FTE time £- £- £- £- £6,820.00 £6,820.00 £6,820.00 £6,820.00 £- £- £- £- £27,280.00


    The challenge is that I have X many rows, and I don't know in advance how many these could be.
    I'd like to have a formula that could surface a range of cells, being able to add new rows if required without changing the formula.

    I thought the array formula could have been useful, but I can't figure out how I can get them working giving this particular scenario.

    Any helps?
    Andrea
    Last edited by seoer; 05-25-2016 at 02:05 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Would an array formula be useful to find the total?

    It is much easier to view data in an excel spreadsheet instead of the forum.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    08-08-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Would an array formula be useful to find the total?

    I really wish I can share the doc. The attachment function doesn't allow me to share anything.

    Any other mean I can provide the example?

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Would an array formula be useful to find the total?

    Quote Originally Posted by seoer View Post
    The attachment function doesn't allow me to share anything.
    I had this same problem on another post yesterday. When I click on the paper clip I get a very narrow box not an "Open File" dialogue.
    I don;t usually add many attachments so maybe I'm doing something wrong or something has changed on this board.

    To answer your question, another way is to upload the file to an online storage site like FilesAnywhere and place a link to the file.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  5. #5
    Registered User
    Join Date
    08-08-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Would an array formula be useful to find the total?

    Ok, saved a spreadhseet on dropbox.

    I hope the link will be not killed.

  6. #6
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Would an array formula be useful to find the total?

    Assuming you want a formula in cell N4:
    Please Login or Register  to view this content.

    Otherwise your sample is not really showing me what you want.
    If that is incorrect, show me a slightly larger sample AND indicate what cell(s) you want formulas for.

+ 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. [SOLVED] Formula to Find Total Number of Different Value Variations
    By artiststevens in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-07-2014, 04:04 PM
  2. [SOLVED] Find formula with multiple find (array)
    By dluhut in forum Excel General
    Replies: 3
    Last Post: 05-04-2012, 10:48 AM
  3. Using a formula to find a total from three rows
    By patsyhixon in forum Excel General
    Replies: 7
    Last Post: 01-16-2012, 11:17 AM
  4. Find Total row and insert formula
    By soss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2011, 09:09 AM
  5. Replies: 6
    Last Post: 11-19-2009, 07:08 AM
  6. Using array formula to total entries
    By RichardL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2008, 03:08 AM
  7. a formula to find total compound amount after given number of yea.
    By ronan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2005, 05:06 PM

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