Excel prob help me plz

[farooq talhar]

KINDLY EXCEL EXPERTS HELP ME SEE THE IMAGE

[syar]

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,

[farooq talhar]

Thanks bhai ab image dekhe
allah ap par karam karey

[IT.BOY]

اگر وہ شیٹ ہی یہاں شئیر کر دیں۔۔۔اور آپ کون سا رزلٹ چاہتے ہیں تو بہت اچھا ہو گا۔۔۔اوکے

[farooq talhar]

Kindly closed it shayed is ka koi hal nahi but thanks all(f)

[sayhellotoit]

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.