koi mujhy bta da k excel 2007 ma "subtotal" ka formula kaisy lagaty ha reply jaldi
koi mujhy bta da k excel 2007 ma "subtotal" ka formula kaisy lagaty ha reply jaldi
http://www.itdunya.com/showthread.php?t=163498
aap ye chek karoo aap ka masla hal ho jaiy ga insllah
salam::
aap data k tab m outline k box se subtotal ko select kar sakte hain aur group/ungroup bhee data ko kar sakte hain.
suppose agar aap ka data a1:a10 tak ha aur aap ki kuch row hide hain tu inko sum karne k leye bhee aap subtotal ka function istimal kar sakte hain. kiyon k agar aap sum ka function istimal karain ga tu ye aap ko sub rows ka total de ga. jab k subtotal aap ko visible cells ka total de ga.
=subtotal(109,a1:a10)
regards
Bookmarks