Forum Discussion
Calculating number of set occurence in cells
Hi. I´d like to make a calculation/formula for the number of occurences in a certain range of cells in my excel. But it´s not numbers but simply K or H put in those cells, how do I accomplish that? ...
You would apply a COUNTIF function like below:
=COUNTIF($C$1:$C$3,B$5)If you choose to type the letter to replace B$5, you include quotation marks for text, so the formula would adjust to
=COUNTIF($C$1:$C$3,"K")
- =($DR$13:$FF$13,$FD$18) is my formula where DR13 to FF13 is the cells (in one row) that contains the K´s and H´s and FD18 is the cell where I put K. But excel won´t have it.
Did you add the Countif function in the beginning? Sharing a screenshot can help with identifying any other issues
adversi yes here´s how it looks with my Swedish excel.
- Thanks but that didn´t work either.
