Results 1 to 6 of 6

Array Formula required

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2014
    Location
    Newman, Western Australia
    MS-Off Ver
    2007
    Posts
    3

    Array Formula required

    Hi guys

    I have attached a spreadsheet of data that I would like to reduce.

    In the workbook there is a set of data (rows 1 - 24) which are defined with random dates (row 2) and number criteria column A.

    In the table below that (rows 28 to 37) I have set out how I would like to present the data.

    So the question is; how to create an array formula that sums the above data months into the criteria of column A.

    if there is any help out there please point me in the right direction

    Cheers
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Array formula required to get the Employee details
    By zouraiz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2013, 03:21 PM
  2. [SOLVED] Help with Array formula required
    By johnstan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2013, 09:06 AM
  3. Help Required with counting in Array
    By priamlau in forum Excel General
    Replies: 1
    Last Post: 05-30-2012, 03:42 PM
  4. Array formula help required
    By ZERKproject in forum Excel General
    Replies: 1
    Last Post: 03-16-2011, 06:57 AM
  5. [SOLVED] Array - Object required???
    By Buffyslay in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2006, 03:30 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