hidden rows problem

  • Thread starter Thread starter ataur rahman rony
  • Start date Start date
A

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
 
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-
Click to expand...

use SUBTOTAL instead of SUM


Regards
Claus B.
 
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
Click to expand...

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
Click to expand...



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
Click to expand...

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..
Click to expand...

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


Regards
Claus B.
 
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
Click to expand...

its not working..i send file to your email address.
 
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
Click to expand...

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