I am trying to have my sumifs only display the data that is filtered. right now, when i filter the data, my sumifs still just show the total for all the data, regardless of filter. (im a rookie here)
my sumifs equation is =SUMIFS(Q8:Q,E8:E,"passing yards",G8:G,"over")
i just want this to change based on the filter applied to the data. i cant get it to combine with SUBTOTAL.
please help a newbie here
my sumifs equation is =SUMIFS(Q8:Q,E8:E,"passing yards",G8:G,"over")
i just want this to change based on the filter applied to the data. i cant get it to combine with SUBTOTAL.
please help a newbie here