Sumproduct and subtotal
 

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:c 1000))

regards

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

Sumproduct and subtotal
 

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

In article ,
Marcelo wrote:

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:c 1000))

regards