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
Bookmarks