I need help combining two formulas.
What I need is to subtotal a range based on a criteria and I need that subtotal to change when the range is filtered.
I have two formulas that work separately. Any help in combining them would be greatly appreciated (I have looked at other posts for hours and cannot work it out!)
=SUBTOTAL(9,AW5:AW552)
=SUMIF(AV$5:AW$552,AV558,AW$5:AW$552)
Thanks very much!
SUMIF()
sums a range based on a criteria, while theSUBTOTAL()
sums the results of theSUMIF()
. The idea is that once you filter the rows, theSUBTOTAL()
will sum only rows that are still showing.