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