Excel formula

[RameezAbbasi]

Assalam o alikum,

Mary pass aik excel ke sheet ha jis pr different sizes ky item entry ke han or un ke quantity b likhi ha end pr sum ka formula be lagaya , ab sawal yah ha k ma jab aik size ko filter karon to total sirf usi size ka ana chaey.

Pls expert help

[mehfil_pasnd]

ap ko pivot table ka use karna pare ga


follow this link

http://www.techonthenet.com/excel/pi...create2007.php

[syar]

Assalam o alikum,

Mary pass aik excel ke sheet ha jis pr different sizes ky item entry ke han or un ke quantity b likhi ha end pr sum ka formula be lagaya , ab sawal yah ha k ma jab aik size ko filter karon to total sirf usi size ka ana chaey.

Pls expert help

Regular Sum formula ki jaga aap subtotal ka formula use karain ya pivot table use Karin tu aap ko report banana m asani ho gi.

for example
=subtotal(109,'your range') OR =subtotal(109, a1:a10)

change ranges/references accordingly

regards

[RameezAbbasi]

Thanks g. Ma chata hon yeh farmula , farmula bar pr nazar na ay to kia kron

[syar]

Thanks g. Ma chata hon yeh farmula , farmula bar pr nazar na ay to kia kron

Urdu tutorial k section m aik thread ba hide formula in formula bar. Use visit karain ya excel helpline k thread m bhe aap ko solution mil jae ga.


Regards