Hello ER, and thank you for using this service.
There are a few different ways to do this, but one of the easiest would be the SUM function in the cell you want the total count result to appear.
Use this formula
where range is the range that you want to search, and number is ***** number that you want to count.
Close, but you'll need to put in a range. Example:
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Please remember to rate my time and help to you before you go. I continue to help before and after rating, and strive for excellent service. A positive rating is the only way I receive any credit for helping you today. Thank You.