Need Excel Formula plz

**arifraza** · 19th June 2012, 03:11 PM

Attache file

**The Genius** · 19th June 2012, 04:26 PM

Bhai maine iss file main forumula laga diya he

Agar ap ko iss se be acha forumula mille to mujh se zroor share krna

Thanks

**syar** · 19th June 2012, 04:56 PM

Agar Aap ko sirf values add karne hain tu try

1. Copy/paste in AH7 to add value excluding friday

Code:

=SUMPRODUCT(--($D$5:$AG$5<>"fri"),$D7:$AG7)

2. Copy/paste in AI7

Code:

=SUMPRODUCT(--($D$5:$AG$5="fri"),$D7:$AG7)

***Black*Beauty*** · 19th June 2012, 06:51 PM

very easy......

**justali** · 16th July 2012, 11:09 PM

syar said:

agar aap ko sirf values add karne hain tu try

1. Copy/paste in ah7 to add value excluding friday

Code:

=sumproduct(--($d$5:$ag$5<>"fri"),$d7:$ag7)

2. Copy/paste in ai7

Code:

=sumproduct(--($d$5:$ag$5="fri"),$d7:$ag7)

gud work mere dost

**Haseeb Alamgir** · 16th July 2012, 11:27 PM

اگر آپ کا مسلہ حل ہو گیا ہے تو تھریڈ بند کر دیا جائے؟

Thread: Need Excel Formula plz