I wish to add a row of cells that contain €œx€� or €œxx€� or €œxxx€� etc this I can
do with:-

=SUM(COUNTIF(C47:G47,"x")+COUNTIF(C47:G47,"xx")+CO UNTIF(C47:G47,"xxx")+COUNTIF(C47:G47,"xxxx")+COUNT IF(C47:G47,"xxxxx"))

The above gives me a count of the number of €œcells€� containing my criteria:-

However I wish to count the occurrences, contents of the cells: of how many
€œx€� in the range?


e.g.
c d e e f
x xx x xxx = 7

I am new to this nay help would be gratefully received!