Using functions such as Sum, Average and Count in Excel is fine until you need to apply those functions to filtered data. That’s when the trouble starts as these functions ignore the filter and return the results for the entire range. In this situation, the SUBTOTAL function is your friend.