reply jaldi Excel help

[jaguar_paw]

koi mujhy bta da k excel 2007 ma "subtotal" ka formula kaisy lagaty ha reply jaldi

[Dil_Shah]

http://www.itdunya.com/showthread.php?t=163498

aap ye chek karoo aap ka masla hal ho jaiy ga insllah

[syar]

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