Hi everyone. I'm new here. Hope you can help ne out.
Is it possible to change the cell reference of a formula depending on the filtered cells?
My data has about 1200 rows x 7 columns. Most of the time, I filter my data (say, by date).
So can I automatically update the formula so it calculates only on the filtered data?
Thanks!
Bookmarks