Original Blog Entry: Pick 3 Excel Formula Digit Returns

winsumloosesum — Fri, 25 Dec 2009 14:50:40 GMT

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}) COUNTIF(A2:C2,{0,1,2,3,4,5,6,7,8,9}),COUNTIF(A1:C1,{0,1,2,3,4,5,6,7,8,9}),COUNTIF(A2:C2,{0,1,2,3,4,5,6,7,8,9})))

Then press the following keys at the same time (Control - Shift - Enter) on your keyboard. You should see { } at the beginning and end of the formula.

... [ More ]