Become a Govt. Certified GST Practitioner. Batch begins 18th Nov. Register Now!

How to avoid SUm formula on hide cells

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.

Reply
Follow
Share

4 Replies

Ravishankar K (Accountant) (461 Points)
Replied 04 June 2011

instead of sum use Subtotal(9,range)

Upgrade to CAclubindia Pro. Subscribe Now!

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