Forum Discussion
Andreas_Nordin
Nov 18, 2020Copper Contributor
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? ...
Riny_van_Eekelen
Nov 18, 2020Platinum Contributor
Andreas_Nordin Look into the COUNTIF function
Andreas_Nordin
Nov 18, 2020Copper Contributor
Riny_van_Eekelen Thanks I have done that without any success unfortunately. Seems all examples I find is based on cells with numbers. I simply want excel to count the number of K´s in a certain row and then the number of H´s in another.