|
hidden rows problem
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 |
hidden rows problem
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 |
hidden rows problem
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.. |
hidden rows problem
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 |
hidden rows problem
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. |
hidden rows problem
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 |
hidden rows problem
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 |
hidden rows problem
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.... |
| All times are GMT +1. The time now is 03:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com