Excel: Couting numbers inside one cell or a range of cells

Let's say my A1 cell looks like this: 1, 1, 1, 1, 1, 5, 3, 1, 1 My A2 cell looks like this: 1, 2, 1, 1 The numbers are separated by a comma. I want to count how many times a number 1 appears in a cell A1 (7) and in a range of cells A1:A2 (10). Can you help me out?

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of August 28, 2014.

For more resources for Microsoft Excel