I need a formula that will count the total number of times several numbers appear on each row of worksheet and display the result on each row. For example, in the table below, the numbers 10, 43, and 85 show up 3 times in row A2-I2 and 2 times in A3-I3. These totals are displayed in cells J2 and J3 respectively.
A2 B2 C2 D2 E2 F2 G2 H2 I2 J2
-- -- -- -- -- -- -- -- -- -- --
01 10 43 44 57 66 72 85 99 03
A3 B3 C3 D3 E3 F3 G3 H3 I3 J3
-- -- -- -- -- -- -- -- -- -- --
08 12 27 32 43 57 69 71 85 02
I've searched all over and have tried many different variations of "COUNTIF", "COUNTIFS" but I can't figure it out. I've also tried these functions putting the numbers to count as arrays (using control-shift-enter) but no success.
The worksheet contains thousands of numbers (formatted as numbers) on hundreds of rows. The numbers to search for in each row will always be 10, 43, and 85. The numbers on each row range from 01-99 and never repeat on the same row.
Appreciate your help.
Bookmarks