hidden rows problem

[ataur rahman rony]

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

 

[Claus Busch]

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.

 

[ataur rahman rony]

Hi,



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






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

Hi,



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






use SUBTOTAL instead of SUM





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Hi,



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






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

 

[Claus Busch]

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.

 

[ataur rahman rony]

Hi,



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






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.

 

[ataur rahman rony]

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

hi,
did u get my mail

 

[Claus Busch]

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.

 

[ataur rahman rony]

Hi,



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






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