I'm trying to find the 30 day average from a table of data with filtered cells. I originally had a my formulas setup with raw data not in a table format. The formulas worked beautifully until I changed it up and created tables from a master list of data for multiple types of queries. Once I did this I ran into hidden/filtered cells giving me inaccurate results. I have a column of dates and a column of numbers which are gathered from the difference between two dates. I'm looking for the average from the last 30 days. Here is the original formula I was using =AVERAGEIFS(!K$1:K$117,!E$1:E$117,">="&TODAY ()-30) where column K Has the data and column E has the dates. I believe I need to incorporate subtotal and offset into my formula to ignore hidden cells, but I can't seem to get it to work with the rolling 30 criteria. I have spent all day searching Google to point me in the right direction but I cannot get it to work. Can somebody please assist? Thank you
Bookmarks