I need a formula to count specific values in a range of data. For example, say I have the values 0, 1, 2 and 3 in a column and want to know how many "1's" are in the column. I have experimented with combinations of IF and COUNT and DCOUNT without success.
It would be helpful if I can count specified text entries as well as numerical values.
Can anyone help?
It would be helpful if I can count specified text entries as well as numerical values.
Can anyone help?