calculate filetred cells only

  • Thread starter Thread starter Manikandan
  • Start date Start date
M

Manikandan

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
 
Manikandan said:
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
Click to expand...
 
Back
Top