Skip to content
Home
Tutorials
Real-World Examples
Count cells if ends with
Update Formula
Parameters
Formula
Range Reference:
Specific value:
enter the value that you want to count for if a cell ends with this value
Formula:
=
COUNTIF
(
B8:B14
,"*
es
")
=
COUNTIF
(B8:B14,"*es")