How cud I avoid sum formula to hide cells. I mean when we use sum formula to total some digits, it adds hide cells value also, which create a lots of problem in my work.
Is there any way so that I cud overcome this problem. Please guide me.
JMD (STUDENT) (563 Points)
22 April 2011
How cud I avoid sum formula to hide cells. I mean when we use sum formula to total some digits, it adds hide cells value also, which create a lots of problem in my work.
Is there any way so that I cud overcome this problem. Please guide me.
JMD
(STUDENT)
(563 Points)
Replied 06 June 2011
thanks. i tried and cudn't succeed. so pls clear me with an example.
JMD
(STUDENT)
(563 Points)
Replied 06 June 2011
Thanks Ravi, Now it is working as my problem is sorted out using 109 instead of 9.
Thanks a lot and keep smilinggg.....:)
Regds,
JMD
Ravishankar K
(Accountant)
(461 Points)
Replied 07 June 2011
WElcome its learning for all of us even i did not know about Subtotal 109, but the Subtotal 9 is used where cells get hidden in filtering the cells ,cheers keep learning
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
