Hi to everyone.
I need a function that counts how many times one value exists in a specific range.
For example in the table below i need to count value from cell A1 = 42 how many times exist in the range A11:E19
In the specific example value 42 exist ones in the second area (table).
42 39 16 9 5
24 14 20 9 30
1 3 30 16 23
39 42 14 18 15
27 39 42 41 1
5 29 44 15 16
24 28 32 25 18
15 9 22 42 5
18 20 1 34 4
12 13 18 32 34
1 21 9 26 34
9 43 14 10 17
23 43 11 4 34
24 28 15 17 33
6 25 17 11 9
22 21 42 27 15
22 25 37 18 23
19 32 31 10 2
Thanks in advance for your valuable time
Manos
Bookmarks