+ Reply to Thread
Results 1 to 2 of 2

Array using named references

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    New York, NY
    MS-Off Ver
    Excel Mac 2011
    Posts
    6

    Array using named references

    I have a simple array - actually, many similar arrays or I wouldn't care about this issue. This is about compiling monthly and annual statistics for a web site. How would I write the array formula so it will fill in the monthly totals? What I think should work, doesn't.

    Array Formula.xlsx

    I would have thought that either ={sum (_Vis2013 Jan:Dec)} or ={(_Vis2013 Jan:_Vis2013 Dec)}
    would have worked, but they don't.

    _Vis2013 is a column with the site daily visitors for the year. Jan is 31 row (1 per day) region spanning years and data types (visitors for 2008-2013, # of transactions, revenue, conversion rate, customer count, etc.).

    The basic formula works fine =sum(_Vis2013 Jan) gives me the the number of site visitors in January 2013. I just have about 20 KPIs we're tracking, an I really don't want to have to either type the formulas for each month. I double checked, and Jan-Dec is a valid list.

    Any ideas?

    Paul

  2. #2
    Registered User
    Join Date
    03-11-2013
    Location
    New York, NY
    MS-Off Ver
    Excel Mac 2011
    Posts
    6

    Re: Array using named references

    Bump no response

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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