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

Count Number of Unique Cells That Don't Have Certain Characters 0
Count if data falls within a range AND that has a certain criteria 1
Sumproduct in Excel 2003 3
if formula results in False - can you help? 1
Sumproduct seems off... HELP PLEASE! 3
sumproduct and subtotal but with 2 conditions 1
sumproduct with text 1
Sum total using Sumproduct if two criteria met 5

Top