Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Subtotal
I have the following formula and would like to use a subtotal, can anyone help?
=SUMPRODUCT((O21:O10060)*(N21:N1006=0)*($C21:$C10 06)) Essentially the formula is counting addition of vehicles in the current month. i.e. Counts if the col O0 and col N equals 0 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Subtotal
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:O10060)*(N21:N1006=0),$C21:$C1006) If this post helps click Yes --------------- Jacob Skaria "Bec" wrote: I have the following formula and would like to use a subtotal, can anyone help? =SUMPRODUCT((O21:O10060)*(N21:N1006=0)*($C21:$C10 06)) Essentially the formula is counting addition of vehicles in the current month. i.e. Counts if the col O0 and col N equals 0 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Subtotal #Value! error | Excel Worksheet Functions | |||
Another SUMPRODUCT SUBTOTAL question... | Excel Worksheet Functions | |||
nesting sumproduct with subtotal | Excel Worksheet Functions | |||
Sumproduct and subtotal | Excel Worksheet Functions | |||
Subtotal - Can I use Sumproduct ? | Excel Discussion (Misc queries) |