calculate filetred cells only
 

Sir,
I am having a worsheet data which contains Salesperson Name, Month, Sales &
Sub Group. If i select one Sub Group from the filtered option, it will
dispaly the details of that specified sub Group, but i want to display the
total of Sales figures in the last row of the data. How can i got this value
from the filtered data??
Please help out...
Regards,
M.Manikandan

calculate filetred cells only
 

"Manikandan" wrote:

Sir,
I am having a worsheet data which contains Salesperson Name, Month, Sales &
Sub Group. If i select one Sub Group from the filtered option, it will
dispaly the details of that specified sub Group, but i want to display the
total of Sales figures in the last row of the data. How can i got this value
from the filtered data??
Please help out...
Regards,
M.Manikandan

calculate filetred cells only
 

Manikandan;233745 Wrote:
Sir,
I am having a worsheet data which contains Salesperson Name, Month,
Sales &
Sub Group. If i select one Sub Group from the filtered option, it will
dispaly the details of that specified sub Group, but i want to display
the
total of Sales figures in the last row of the data. How can i got this
value
from the filtered data??
Please help out...
Regards,
M.Manikandan

You can use a Pivot Table or the SUBTOTAL function as described 'here'
(http://www.contextures.com/xlFunctions01.html#Filter)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65252

calculate filetred cells only
 

Hi,

To sum up filtered data in a range, you may use the SUBTOTAL(9,range)
function.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manikandan" wrote in message
...
Sir,
I am having a worsheet data which contains Salesperson Name, Month, Sales
&
Sub Group. If i select one Sub Group from the filtered option, it will
dispaly the details of that specified sub Group, but i want to display the
total of Sales figures in the last row of the data. How can i got this
value
from the filtered data??
Please help out...
Regards,
M.Manikandan

calculate filetred cells only
 

Yes, it is working fine, thanks!!

Regards,
Manikandan.

"Ashish Mathur" wrote:

Hi,

To sum up filtered data in a range, you may use the SUBTOTAL(9,range)
function.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manikandan" wrote in message
...
Sir,
I am having a worsheet data which contains Salesperson Name, Month, Sales
&
Sub Group. If i select one Sub Group from the filtered option, it will
dispaly the details of that specified sub Group, but i want to display the
total of Sales figures in the last row of the data. How can i got this
value
from the filtered data??
Please help out...
Regards,
M.Manikandan

calculate filetred cells only
 

You are welcome.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manikandan" wrote in message
...

Yes, it is working fine, thanks!!

Regards,
Manikandan.

"Ashish Mathur" wrote:

Hi,

To sum up filtered data in a range, you may use the SUBTOTAL(9,range)
function.

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Manikandan" wrote in message
...
Sir,
I am having a worsheet data which contains Salesperson Name, Month,
Sales
&
Sub Group. If i select one Sub Group from the filtered option, it will
dispaly the details of that specified sub Group, but i want to display
the
total of Sales figures in the last row of the data. How can i got this
value
from the filtered data??
Please help out...
Regards,
M.Manikandan