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")
Thanks but that didn´t work either.