Description:
This formula counts the identified character(s) within a reference value.
This formula counts the identified character(s) within a reference value.
Formula/Syntax:
=LEN(Reference)-LEN(SUBSTITUTE(LOWER(Reference, Character(s),"")
=LEN(Reference)-LEN(SUBSTITUTE(LOWER(Reference, Character(s),"")
Example:
Disclaimer: The owners of this site wish to express that no official relationship exists between this site and Microsoft Corporation. Any view or opinion should not be associated in any way, shape, or form as the views of Microsoft Corporation. Any service and/or product offered from this site is not an official product of Microsoft Corporation and will not be supported, advertised, or construed as such.