Hello friends, Does anyone know a way to avoid calculating #N/A cells? =SUM(INDEX(COUNTIF(B1:B11,D1:D11&"<>#N/A"),0)) ,does not work , The correct result is 12 Thanks for the helpers David