Dear Members
to calculate a specific value I want to use the following formula
=SUMPRODUCT(--((ISNUMBER(SEARCH("MA-02",MTN!M2:M90000))))) its working perfectly
but I want to do this with tow conditions ie with this part of coding
,MTN!M2:M90000,MTN!$B$2:$B$90000,"="&'G Report'!$Z$3,MTN!$B$2:$B$90000,"<="&'G Report'!$AA$3)
and I also change the SUMPRODUCT into SUMIFS
the formula change into this shape but its not working and giving an error
=SUMIFS(--((ISNUMBER(SEARCH("MA-02",MTN!M2:M90000,MTN!$B$2:$B$90000,"="&'G Report'!$Z$3,MTN!$B$2:$B$90000,"<="&'G Report'!$AA$3)
If someone knows about this please help me
thanks
to calculate a specific value I want to use the following formula
=SUMPRODUCT(--((ISNUMBER(SEARCH("MA-02",MTN!M2:M90000))))) its working perfectly
but I want to do this with tow conditions ie with this part of coding
,MTN!M2:M90000,MTN!$B$2:$B$90000,"="&'G Report'!$Z$3,MTN!$B$2:$B$90000,"<="&'G Report'!$AA$3)
and I also change the SUMPRODUCT into SUMIFS
the formula change into this shape but its not working and giving an error
=SUMIFS(--((ISNUMBER(SEARCH("MA-02",MTN!M2:M90000,MTN!$B$2:$B$90000,"="&'G Report'!$Z$3,MTN!$B$2:$B$90000,"<="&'G Report'!$AA$3)
If someone knows about this please help me
thanks
Last edited: