Hello all,
I seem to have issues putting my problem into a title, I'm looking to explain my situation here below:
Please look at the attached excel file to help clarify what I'm looking to do. I'm adding data manually to the bottoms of columns A, B, and C every week. I would like to get metrics off of this data such as average age, total count per week, count per day, etc. What I think would be very helpful and slick is if after manually adding in the data, all of my metrics formulas would automatically update their source ranges, and thus have accurate "real-time" solutions. I mostly understand how to grab the averages and sums and what not, but I'm struggling to find a way to automate the process. there is a lot of drag and fill going on that I was hoping could be made automatic.
So... As i add data (Cols A,B,C) can my G, H, J, and K columns automatically add in the fields?
Any other ways of doing this would be accepted and appreciated too! I'm not fond of pivot tables though as I'm not familiar with them and they seem to use up a lot of space with basically the same data I already have...
Thank you!
AustinSampleExcel.xlsx
Bookmarks