com] *On Behalf Of *Muhammad Arslan
>> *Sent:* Apr/Wed/2012 05:49
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ How to use subtotal in sumif formulae
>>
>> ** **
>>
>> I am trying to use SUBTOTAL with a nested SUMIF
>> like
-macros@googlegroups.com] *On Behalf Of *Muhammad Arslan
> *Sent:* Apr/Wed/2012 05:49
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ How to use subtotal in sumif formulae
>
> ** **
>
> I am trying to use SUBTOTAL with a nested SUMIF
> like so
>
>
$$ How to use subtotal in sumif formulae
I am trying to use SUBTOTAL with a nested SUMIF
like so
=SUBTOTAL(109,(SUMIF(AB11:AB249,"<0",AB11:AB249))
I only want the sum_range to sum based on a filter, and thus the SUBTOTAL.
I know this is not possible the way I have it , because it i
I am trying to use SUBTOTAL with a nested SUMIF function
like so
=SUBTOTAL(109,(SUMIF(AB11:AB249,"<0",AB11:AB249))
I only want the sum_range to sum based on a filter, and thus the SUBTOTAL.
I know this is not possible the way I have it , because it is not working,
but is it possible some other wa
