I’m trying to include into this formula the iserror fuction. If I include the (ISERROR at the start and at the end add ,””, the repeat the formula it won’t work. Am I missing the obvious?
=SUMPRODUCT(--(ISNUMBER(SEARCH(T7,Staff_Name))),--(Date_Range>=Sqtr1),--(Date_Range<=Fqtr1),--(Product_Quality)/U7)
=SUMPRODUCT(--(ISNUMBER(SEARCH(T7,Staff_Name))),--(Date_Range>=Sqtr1),--(Date_Range<=Fqtr1),--(Product_Quality)/U7)