I want to use the AVERAGEIF, SUMIF AND COUNTIF functions but want them to only apply to the visible data on a filtered table. When i use AVERAGEIF it applies to all the data in the table even when the filter is applied to the table. How do i get it to only apply to the visible data on the table?