Sumproduct Subtotal

  • Thread starter Thread starter Bec
  • Start date Start date
B

Bec

I have the following formula and would like to use a subtotal, can anyone help?

=SUMPRODUCT((O21:O1006>0)*(N21:N1006=0)*($C21:$C1006))

Essentially the formula is counting addition of vehicles in the current
month. i.e. Counts if the col O>0 and col N equals 0
 
If you are looking to ignore the hidden values try the below

=SUMPRODUCT(SUBTOTAL(3,OFFSET($C21:$C1006,ROW($C21:$C1006)-MIN(
ROW($C21:$C1006)),0,1)),--(O21:O1006>0)*(N21:N1006=0),$C21:$C1006)

If this post helps click Yes
 
Back
Top