Excel help needed

**ITDWARRIOR** · 11th July 2012, 08:53 PM

Dear friends yeh main ek file share ker raha hon is file k ander mainy likh diya hai k mujhe kiya result chahiye.

Please download this file or agar koi meri help ker sakta hai tu mehirbani hogi

**waqaskhan722** · 11th July 2012, 10:06 PM

YAR YHAN WRITE KR DO KIA FARMOLA USE KRNA HY I AM USING MOBILE SORY FOR THIS

**syar** · 11th July 2012, 10:35 PM

try
I7

Code:

=SUMPRODUCT(--(dates>I4),--(dates<J4),--($C$2:$C$120=I5),$D$2:$D$120)

J7

Code:

=SUMPRODUCT(--(dates>I4),--(dates<J4),--($C$2:$C$120=I5),$E$2:$E$120)

K7

Code:

=SUMPRODUCT(--(dates>K4),--(dates<L4),--($C$2:$C$120=K5),$D$2:$D$120)

L7

Code:

=SUMPRODUCT(--(dates>K4),--(dates<L4),--($C$2:$C$120=K5),$E$2:$E$120)

You can use sumifs instead of sumproduct if u are using xl 2007/2010. Agar aap ka desire result nahee ha tu COndition (<,>) ko change kar k dekh lain aur ranges/references apne marze k mutabiq adjust kar lain. AUr agar ho sake tu merge cell khatam kar dain.

aur count karne k leye aap COUNTIFS ka function use karain.

regards

**ITDWARRIOR** · 12th July 2012, 08:16 AM

thanks syar bhai for reply me.

dear main countifs or sumifs ko use karon magar us main dates per kese condition lagaon. agar laga raha hon tu result zero araha hai.

main jo formula laga raha hon estimates per countifs ka woh yeh hai.

=COUNTIFS(F2:F120,">1",C2:C120,"Res",dates,">I4",d ates,"<J4")

or main excel 2007 use ker raha hon. magar itdunya ki attachment main xlxs ki file attach nahin ho rahi thi tu is liye 2003 main save as ker k send ki hai.

**ITDWARRIOR** · 12th July 2012, 08:25 AM

syar bhai ap ny jo formula kaha tha k dikhana ke kese mod k function se auto Sunday arahy hain..

dar asal jis dost k pass mainy woh formula dekha tha us se meri thori 19 20 hogai hai. kiyun k mainy us ko yeh kaha tha k bhai mujhe yeh sheet send karo tu main is formuly ko dekhon magar 3 4 baar kehny k bawjood bhi us ny mujhe woh sheet nahin di is liye thori 19 20 ho gai hai.

main ap se sorry karonga k ap ny first time koi kam kaha or main woh nahin ker paya.
magar agar mujhe woh formula mill gaya tu main ap ko zaroor dikhaonga.
main janta hon ap excel k Mashallah expert ho or ap ko ese formuly ki koi zaroorat nahin hai. magar mujhe tu ap ny first time koi kam kaha tha na jo main nahin ker paya..

ek baar fir sorry ker raha hon.

**syar** · 12th July 2012, 11:45 PM

Bhai itne chote chote bataon p doston sa naraz nahee hote. m n kaha tha k konsa formula use kya ha k m deekh sakon. Mujhy 7,8 formulas aate hain jo k MOD ko use kar k weekdays, networkdays etc maloom karte hain. is leye aap tension mat le.Sorry karne ki zaroorat nahee ha. Yahan ham sab log ak dosre ki madad karne k leye hain. mujhy kuch ata ha tu mujhy share karne m koi masla nahee ha. aur jo aap ko ata ha wo aap share karte hain. is m sorry karne ki koi zaroorat nahee ha.

**syar** · 13th July 2012, 12:46 PM

Hamare Swat m aaj kal light ka bara masla ha is leye kal m aap ko pora reply nahee d saka.

Aap apna masla formula use keye bagheer bhe hal kar sakte hain. is k leye aap pivot table use karain. Aap k masla ki had tak tu m n screen shots deye hain. Umeed ha k aap ki kisi had tak madad ho jae gi. aur kuch naya bhee sekh jaen ge. agar aap ko phr bhe confusion ho tu m aap ko formula bta donga. Screenshot thore dim hain. aap enhance kar lejeya ga.

regards

**sohail1966** · 13th July 2012, 03:02 PM

Very nice syar bhai, akhir kar apne bhi screen shorts de hi deye,
Thanks,

**ITDWARRIOR** · 13th July 2012, 09:59 PM

yar syar bhai Allah ap ko khush rakhy gr8 yar..

syar bhai main pivot table ko use karonga.. dar asal mere pass buhat sari fields hain jin ki main samary banana chahta hon. is liye ap se formula pocha tha taky woh formula her field per use karon..

ab yeh pivot table per kam karonga Allah k hukum se or ap ki duaon se yeh samajh main ajaegi.

**ITDWARRIOR** · 13th July 2012, 11:12 PM

syar bhai mainy jo summary banai hai woh main yahan share nahin ker sakta werna main ap ko dikhata k mere pass kitni fields hain jin ka mujhe date wise every time update chahiye hota hai.. mere khayal se itni sari fields pivot table main nahin asakti.. ya agar ap apni mujhe e-mail address de sakty hain tu main ap ko apni summary us per send karonga.
mera PM bhi nahin ho raha kiyun k meri posts itni nahin hain k PM ho saky

**syar** · 14th July 2012, 05:34 PM

ITDWARRIOR said:

syar bhai mainy jo summary banai hai woh main yahan share nahin ker sakta werna main ap ko dikhata k mere pass kitni fields hain jin ka mujhe date wise every time update chahiye hota hai.. mere khayal se itni sari fields pivot table main nahin asakti.. ya agar ap apni mujhe e-mail address de sakty hain tu main ap ko apni summary us per send karonga.
mera PM bhi nahin ho raha kiyun k meri posts itni nahin hain k PM ho saky

AAp apna sample data share kar dain jis m sare field hain. 02 ya 03 rows ka data enter karain. Aur aap k expected output result kese chahte hain. wo bhe sample attache kar dain. m dekh kar aap ko recomend kar sakonga ya kisi dosre dost ko is k bare m bahtar maloom ho tu wo bhe aap ki madad kar sake ga.

regards,