| 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) | |||
Linear Mode
