hi,
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-

rows date particulars Dr Cr total actual shown
should be
1 02.08.10 paid by cash 4500 4500 4500
4 02.08.10 paid by cash 8000 12500 wrong ans
8 03.08.10 paid by cash 4000 16500 wrong ans
10 04.08.10 paid by cash 6000 22500 wrong ans

but in total column it calculate unhide rows when i dragging and give wrong ans.is there is any formula that i can calculate dis visible rows only..thnx

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

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..

Hi,

Am Fri, 30 May 2014 06:32:18 -0700 (PDT) schrieb ataur rahman rony:

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

the syntax is =SUBTOTAL(9,A1:A100)
If it does not work send the file to my email address


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

On Friday, May 30, 2014 7:47:53 PM UTC+6, Claus Busch wrote:
Hi,



Am Fri, 30 May 2014 06:32:18 -0700 (PDT) schrieb ataur rahman rony:



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



the syntax is =SUBTOTAL(9,A1:A100)

If it does not work send the file to my email address





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

its not working..i send file to your email address.

On Saturday, May 31, 2014 8:14:34 AM UTC+6, ataur rahman rony wrote:
On Friday, May 30, 2014 7:47:53 PM UTC+6, Claus Busch wrote:

Hi,







Am Fri, 30 May 2014 06:32:18 -0700 (PDT) schrieb ataur rahman rony:







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







the syntax is =SUBTOTAL(9,A1:A100)



If it does not work send the file to my email address











Regards



Claus B.



--



Vista Ultimate / Windows7



Office 2007 Ultimate / 2010 Professional



its not working..i send file to your email address.

hi,
did u get my mail

Hi,

Am Fri, 30 May 2014 20:49:17 -0700 (PDT) schrieb ataur rahman rony:

did u get my mail

I answered your mail


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

On Saturday, May 31, 2014 12:04:28 PM UTC+6, Claus Busch wrote:
Hi,



Am Fri, 30 May 2014 20:49:17 -0700 (PDT) schrieb ataur rahman rony:



did u get my mail



I answered your mail





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

thanx a looooootttt claus..i get ur mail......its now working....