Special thanks to Excel experts at mrexcel. Excel formula for calculating the number of digit returns from the previous drawing. For example: if in cells a1, b1, c1 2 0 0 if in cells 0 2 2 In cell d1 enter the following formula: =SUMPRODUCT(IF(COUNTIF(A1:C1,{0,1,2,3,4,5,6,7,8,9})