Hi,

Am Thu, 29 May 2014 20:45:33 -0700 (PDT) schrieb ataur rahman rony:

i dont knw is it possible or not and have small idea about excel.my worksheet rows is filtered..and there is some hide rows.and i want to sum only those filtered data that is visible. as like-

use SUBTOTAL instead of SUM


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional