Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a command like subtotal but with a conditional?
I want to perform several calculations but using something like subtotal()
but taking consideration of certain conditions like sumif(), in others words, sumif() works but doesn´t change when i manipulte the filters and subtotal() works with the filters but not with the diferent conditions... What can i do? |
#2
|
|||
|
|||
One solution
=SUMPRODUCT(--($B$2:$B$2005),--($A$2:$A$200),--(SUBTOTAL(3,OFFSET($B$2,ROW( $B$2:$B$200)-MIN(ROW($B$2:$B$200)),,)))) will sum values in a filtered list where B2:B200 5 and sum the corresponding cells in A -- Regards, Peo Sjoblom "Hiughs" wrote in message ... I want to perform several calculations but using something like subtotal() but taking consideration of certain conditions like sumif(), in others words, sumif() works but doesn´t change when i manipulte the filters and subtotal() works with the filters but not with the diferent conditions... What can i do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using more than one subtotal with same data set | Excel Worksheet Functions | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Subtotal by two columns at once | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Subtotal And Countif | Excel Discussion (Misc queries) |