Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Count cells with string


I am trying to count in Calc all the cells with a given string. Say that my string is in cell E2, I am trying to count all the occurrences of that string in B7:R29. I tried using COUNTIF(B7:R29, E2) but it does not work.

Is there any body that has any idea how to do this?

Thanks a lot!