Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate percentage of cells that have any value | Excel Discussion (Misc queries) | |||
Calculate Filtered Cells Only | Excel Worksheet Functions | |||
Cells will not calculate | Excel Discussion (Misc queries) | |||
cells will not calculate | Excel Worksheet Functions | |||
HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0" | Excel Worksheet Functions |