Hi,
What I'm trying to do is find averages by month based off of a multi year daily data range.
Let's say I have a larger daily time series in Column A, data to Average in Column B, & and Just months and Years in Column C. Like this:
(A)Daily Dates for a few years (B) Matching data per each date (C) Jan '15, Feb '15, Mar '15...
I've been trying to get Array's to work for this but the only one I could get to work was not returning the correct average. I've not had success with SUMPRODUCT. I've been beating myself up on this all day yesterday and I'm stuck. Any help is greatly appreciated.
Thanks
Bookmarks