KINDLY EXCEL EXPERTS HELP ME SEE THE IMAGE
KINDLY EXCEL EXPERTS HELP ME SEE THE IMAGE
Last edited by farooq talhar; 9th February 2012 at 11:08 AM.
As per your screen shot agar ap yellow cells ko multiply karna chahte hain tu
=product(yourrange)
agar sum karna chahte hain tu
=sum('yourrange')
lekan behtar ho ga k ap thodi se mazeed wazahat kar dain k kya ap ka ye matlab to nahee k sirf un values to total karain jo k yellow hon.
regards,
Thanks bhai ab image dekhe
allah ap par karam karey
اگر وہ شیٹ ہی یہاں شئیر کر دیں۔۔۔اور آپ کون سا رزلٹ چاہتے ہیں تو بہت اچھا ہو گا۔۔۔اوکے
[FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]
Kindly closed it shayed is ka koi hal nahi but thanks all(f)
Green wala cell jiss ko aap nay circle kia hova hay (cell L11), wahan yeh formula likh dain:
=E11*$E$9+F11*$F$9+G11*$G$9+H11*$H$9+I11*$I$9+J11* $J$9+K11*$K$9
baqi cell mein yehi formula copy kernay ka tariqa:
Ab iss cell kay lower right-corner pay mouse lay ker jaien, aap ka mouse + sign ki tarha ho jayay ga, ab drag ker kay neechay lay ayain, takeh L column mein baqi cells mein bhi yehi formula copy ho jayay.
Bookmarks