Is there a command like subtotal but with a conditional?

[Hiughs]

I want to perform several calculations but using something like subtotal()
but taking consideration of certain conditions like sumif(), in others words,
sumif() works but doesn´t change when i manipulte the filters and subtotal()
works with the filters but not with the diferent conditions... What can i do?

 

[Peo Sjoblom]

One solution


=SUMPRODUCT(--($B$2:$B$200>5),--($A$2:$A$200),--(SUBTOTAL(3,OFFSET($B$2,ROW(
$B$2:$B$200)-MIN(ROW($B$2:$B$200)),,))))

will sum values in a filtered list where B2:B200 > 5 and sum the
corresponding cells in A



--

Regards,

Peo Sjoblom

I want to perform several calculations but using something like subtotal()
but taking consideration of certain conditions like sumif(), in others words,
sumif() works but doesn´t change when i manipulte the filters and subtotal()
works with the filters but not with the diferent conditions... What can i

do?