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? ...
=($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