On Friday, May 30, 2014 12:15:01 PM UTC+6, Claus Busch wrote:
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

AFTER USING (SUBTOTAL,109),THERE IS NO RESULT...
SIR, HOW CAN I ATTACHED MY FILE HERE,,THAT WILL BE EASY TO FIND SOLUTION.!!



On Friday, May 30, 2014 12:15:01 PM UTC+6, Claus Busch wrote:
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



On Friday, May 30, 2014 12:15:01 PM UTC+6, Claus Busch wrote:
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

SIR,
YM TRYING (SUBTOTAL,109).BUT ITS NOT WORKING. HOW CAN I ATTACHED FILE HERE,THIS WILL BE BETTER FOR FIND SOLUTION..