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.*
--
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 kalx...@gmail.com 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(RIGHT(H9,LEN(H9)-FIND( ,H9,1
--
Thanks regards,
Noorain Ansari
Both are working perfectly.
Thank u Viper
Thanks a lot Noorain
On Fri, Sep 16, 2011 at 5:48 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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(
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),FIND(
