Re: $$Excel-Macros$$ Problem with Sumifs formula

2011-09-16 Thread Ms-Exl-Learner .
Hi Kalyan, Try the below formula. =SUMPRODUCT((TRIM(A2:A37)=TRIM(F11))*(TRIM(B2:B37)=TRIM(G7))*(LEFT(TRIM(C2:C37),3)=LEFT(TRIM(G8),3))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)>=--MID(TRIM(G8),FIND(" ",TRIM(G8))+1,255))*(--MID(TRIM(C2:C37),FIND(" ",TRIM(C2:C37))+1,255)<=--MID(TRIM(G9),FIN

Re: $$Excel-Macros$$ Problem with Sumifs formula

2011-09-16 Thread Kal xcel
Both are working perfectly. Thank u Viper Thanks a lot Noorain On Fri, Sep 16, 2011 at 5:48 PM, NOORAIN ANSARI wrote: > Dear Kalyan, > > Please see attached sheet.. > > =SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,">="&INT(RIGHT(H8,LEN(H8)-FIND(" > ",H8,1))),$C$2:$C$37,"<="&INT(

Re: $$Excel-Macros$$ Problem with Sumifs formula

2011-09-16 Thread NOORAIN ANSARI
Dear Kalyan, Please see attached sheet.. =SUMIFS($E$2:$E$37,$A$2:$A$37,G11,$B$2:$B$37,H7,$C$2:$C$37,">="&INT(RIGHT(H8,LEN(H8)-FIND(" ",H8,1))),$C$2:$C$37,"<="&INT(RIGHT(H9,LEN(H9)-FIND(" ",H9,1 -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Problem with Sumifs formula

2011-09-16 Thread §»VIPER«§
Dear Kalyan why don't you use * =SUMPRODUCT(($A$2:$A$37=F11)*($B$2:$B$37=$G$7)*(--SUBSTITUTE(C2:C37,"MOC","")>=--SUBSTITUTE(G8,"MOC",""))*(--SUBSTITUTE(C2:C37,"MOC","")<=--SUBSTITUTE(G9,"MOC",""))*$D$2:$D$37) * pfa -- *Great day,* *viper * On Fri, Sep 16, 2011 at 4:11 PM, Kal xcel wrote:

$$Excel-Macros$$ Problem with Sumifs formula

2011-09-16 Thread Kal xcel
Dear Experts, I am facing a problem when using sumifs formula, not getting desired result. Plase help me to rectify the problem or better solution. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- ---