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.
Menu
How to avoid SUm formula on hide cells
Replies (4)
instead of sum use Subtotal(9,range)
thanks. i tried and cudn't succeed. so pls clear me with an example.
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
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
Recent Topics :
- Utilising Section 54(F) for capital gains reinvest
- GST ewaybill closure and Bill to ship to GST numbe
- TDS ON PARNTER INTEREST
- Share important chapters of ca inter costing
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
- Error - Blank Rows in Schedule SI (ITR-2)
Related Topics :
CAclubindia
