Sumproduct Subtotal

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct in Excel 2003 3
Sum total using Sumproduct if two criteria met 5
sumproduct with text 1
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column 3
nesting sumproduct with subtotal 9
Sumproduct Help 2
if formula results in False - can you help? 1
SUMPRODUCT Difficulty 11

Top