Sumproduct and subtotal

[Guest]

hi,

I would like to know, if is possible to combine sumproduct and subtotal, eg
=sumproduct(--(a2:a1000="rev")*(b2:b1000="jan");(subtotal(9,c2:c1000))

regards

 

[JE McGimpsey]

What are you trying to do by combining?

SUBTOTAL() returns a single value, so this would multiply the subtotal
by the number of dual matches:

=SUMPRODUCT(--(A2:A1000="rev"), --(B2:B1000="jan")) * SUBTOTAL(9,
C2:C1000)

But that may not be your intent