Re: $$Excel-Macros$$ Counting Visible cell in Pivot

2013-11-24 Thread Chandra Shekar
Hello Ashish, still its showing total for visible cell also that is 6 in this case. Is there any function relate to pivot table? Thanks in advance. Regards, Chandru On Fri, Nov 22, 2013 at 7:39 PM, ashish koul koul.ash...@gmail.com wrote: =SUBTOTAL(3,F:F) On Thu, Nov 21, 2013 at 12:49

Re: $$Excel-Macros$$ Counting Visible cell in Pivot

2013-11-22 Thread ashish koul
=SUBTOTAL(3,F:F) On Thu, Nov 21, 2013 at 12:49 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hello, How to count visible cell in pivot? Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

$$Excel-Macros$$ Counting Visible cell in Pivot

2013-11-20 Thread Chandra Shekar
Hello, How to count visible cell in pivot? Regards, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread