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
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
YAR YHAN WRITE KR DO KIA FARMOLA USE KRNA HY I AM USING MOBILE SORY FOR THIS
try
I7
J7Code:=SUMPRODUCT(--(dates>I4),--(dates<J4),--($C$2:$C$120=I5),$D$2:$D$120)
K7Code:=SUMPRODUCT(--(dates>I4),--(dates<J4),--($C$2:$C$120=I5),$E$2:$E$120)
L7Code:=SUMPRODUCT(--(dates>K4),--(dates<L4),--($C$2:$C$120=K5),$D$2:$D$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.Code:=SUMPRODUCT(--(dates>K4),--(dates<L4),--($C$2:$C$120=K5),$E$2:$E$120)
aur count karne k leye aap COUNTIFS ka function use karain.
regards
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.
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.
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.
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
Very nice syar bhai, akhir kar apne bhi screen shorts de hi deye,
Thanks,
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.
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,
Dear this file is check it...
Book1 solved.xls
Bookmarks