Sumproduct and subtotal

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top