Hi,
I have a problem combining a SUMIF and SUBTOTAL formula into one formula, so i only get the "shown" filtered rows summed when criteria is met. I hope you can help?
=SUMIF($D$5:D25;”Small";E5:E25)
=SUBTOTAL(9;E5:E25)
$D$5:D25 - is the range to look for the word “Small”
“Small” - is...