COUNTA within an IF function

[StefT]

How do I ... count all the non-blank cells with text in it (COUNTA) but only if there is an R in a cell's range (IF)?

Then I'd like to minus one from that result (eg. 5-1 = 4)

I'd like the cell to show nothing (a blank cell or a 0) if there is not an R in that cell range

[Martijnvc]

One solution, requiring you to add a column:

With your range in column A, add the following formula in column B

Please Login or Register  to view this content.

Then SUM column B - 1.