Feel silly asking this question, but I need some help!
- I want to count how many
*
appear in a range of 5 cells. - The cells will range from 0-7
*
each.
I was thinking of using the =COUNTIF(A2:A:6,"*")
function, but if the cell has more than one *
, it doesn't work. Any idea what function I should use or how I can modify my COUNTIF
function to make it work?
Thanks in advance.