|
|
 |
| Author |
Message |
Hinz_u_Kunz
|
 Posted: Sun Nov 14 06:25:38 CST 2004 |
Top |
Excel Misc >> AutoSum and AutoFilter
Hi, when I use an Auto Filter to sort and organize my data, I'd like
cell to perform an autosum on the Totals column.
However, when I use the drop down and pull up just one customer, i
still autosums the entire column, not just the columns that ar
returned by the filter
Any way of only getting the totals for just the columns that ar
filtered
Thank
Balaz
--------
www.coffeecozy.co
Use your Bodum and give up cold coffee for good!
Excel26
|
| |
|
| |
|
Jim
|
| Posted: Sun Nov 14 06:25:38 CST 2004 |
Top |
Excel Misc >> AutoSum and AutoFilter
Use sample =subtotal(9,A2:A100)
> Hi, when I use an Auto Filter to sort and organize my data, I'd like a
> cell to perform an autosum on the Totals column.
>
> However, when I use the drop down and pull up just one customer, it
> still autosums the entire column, not just the columns that are
> returned by the filter.
>
> Any way of only getting the totals for just the columns that are
> filtered?
>
> Thanks
> Balazs
> ---------
> www.coffeecozy.com
>
> Use your Bodum and give up cold coffee for good!
|
| |
|
| |
|
Frank
|
| Posted: Sun Nov 14 06:25:28 CST 2004 |
Top |
Excel Misc >> AutoSum and AutoFilter
Hi
=SUBTOTAL(9,A1:A100)
--
Regards
Frank Kabel
Frankfurt, Germany
> Hi, when I use an Auto Filter to sort and organize my data, I'd like
a
> cell to perform an autosum on the Totals column.
>
> However, when I use the drop down and pull up just one customer, it
> still autosums the entire column, not just the columns that are
> returned by the filter.
>
> Any way of only getting the totals for just the columns that are
> filtered?
>
> Thanks
> Balazs
> ---------
> www.coffeecozy.com
>
> Use your Bodum and give up cold coffee for good!
|
| |
|
| |
|
Aladin
|
| Posted: Sun Nov 14 06:30:43 CST 2004 |
Top |
Excel Misc >> AutoSum and AutoFilter
=SUBTOTAL(9,Range)
Balazs - ExcelForums.com Wrote:
> Hi, when I use an Auto Filter to sort and organize my data, I'd like a
> cell to perform an autosum on the Totals column.
>
> However, when I use the drop down and pull up just one customer, it
> still autosums the entire column, not just the columns that are
> returned by the filter.
>
> Any way of only getting the totals for just the columns that are
> filtered?
>
> Thanks
> Balazs
> ---------
> www.coffeecozy.com
>
> Use your Bodum and give up cold coffee for good
--
Aladin Akyure
-----------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=416
View this thread: http://www.excelforum.com/showthread.php?threadid=27810
|
| |
|
| |
|
Domenic
|
| Posted: Sun Nov 14 06:31:34 CST 2004 |
Top |
Excel Misc >> AutoSum and AutoFilter
=SUBTOTAL(9,A1:A100)
Hope this helps!
Balazs - ExcelForums.com Wrote:
> Hi, when I use an Auto Filter to sort and organize my data, I'd like a
> cell to perform an autosum on the Totals column.
>
> However, when I use the drop down and pull up just one customer, it
> still autosums the entire column, not just the columns that are
> returned by the filter.
>
> Any way of only getting the totals for just the columns that are
> filtered?
>
> Thanks
> Balazs
> ---------
> www.coffeecozy.com
>
> Use your Bodum and give up cold coffee for good
--
Domeni
-----------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1078
View this thread: http://www.excelforum.com/showthread.php?threadid=27810
|
| |
|
| |
|
| |
|