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
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.