SUMProduct formula...but I need to add an extra variable

[davids4500]

Hi....I am using this formula =SUMPRODUCT(--(ISNUMBER(SEARCH("PLNT*",Chreosdata!A2:A6640))),(Chreosdata!P2:P6640*Chreosdata!F2:F6640)), but I need to add another variable... ("CAMP*",Chreosdata!E2:E6640). Where does it fit in the formula that i am using at present? Thank you

 

[Sanjeev1976]

Just going by available information, you can try :

=SUMPRODUCT(--(ISNUMBER(SEARCH("PLNT*",Chreosdata!A2:A6640))),(Chreosdata!P2:P6640*Chreosdata!F2:F6640),--(ISNUMBER(SEARCH("CAMP*",Chreosdata!E2:E6640))))

 

[davids4500]

=SUMPRODUCT(--(ISNUMBER(SEARCH("PLNT*",Chreosdata!A2:A6640))),(Chreosdata!P2:P6640*Chreosdata!F2:F6640),--(ISNUMBER(SEARCH("CAMP*",Chreosdata!E2:E6640))))

Dear Sanjeev1976...you are brilliant and good logic. yes it works and I thank you so much for taking the time to reply. Kindest regards david

 

[Peter_SSs]

I am using this formula =SUMPRODUCT(--(ISNUMBER(SEARCH("PLNT*",Chreosdata!A2:A6640))),(Chreosdata!P2:P6640*Chreosdata!F2:F6640)),

Why do you have an asterisk in the SEARCH function?
ISNUMBER(SEARCH("PLNT" .. would give the same result as ISNUMBER(SEARCH("PLNT*" ... Are you try to confirm that the column A values start with "PLNT"?

 

[davids4500]

Why do you have an asterisk in the SEARCH function?
ISNUMBER(SEARCH("PLNT" .. would give the same result as ISNUMBER(SEARCH("PLNT*" ... Are you try to confirm that the column A values start with "PLNT"?

Thank you so much. Much appreciated.