Countif function?

[BJSinger7623]

I need a formula that will count every time a cell in a column has the # sign and four numbers behind it. Some cells will have more than one. Can't seem to make it work. Any help would - as always - be GREATLY appreciated!

 

[DanteAmor]

Try this:

varios 09ene2024.xlsm
	A	B
1
2	#1234	3
3
4	#2345
5
6	#12
7
8	#4567
9
10	#68 xd
Hoja2

Cell Formulas
Range	Formula
B2	B2	=COUNTIF(A2:A10,"#????")

 

[BJSinger7623]

Try this:

varios 09ene2024.xlsm
	A	B
1
2	#1234	3
3
4	#2345
5
6	#12
7
8	#4567
9
10	#68 xd
Hoja2

Cell Formulas
Range	Formula
B2	B2	=COUNTIF(A2:A10,"#????")

Nope - returns a 0.

 

[BJSinger7623]

Nope - returns a 0.

BUT - you helped me find it!!! THANK YOU!!! Instead of ?'s - *!

 

[BJSinger7623]

Just kidding - it counts ONCE for each appearance in a cell...back to the drawing board!

 

[Joe4]

Are you looking for a count by cell/row, or just a WHOLE total count for an entire range?
Perhaps if you showed us a small example WITH your expected output, it will be clearer.

Also, are you open to an answer that uses VBA?

 

[DanteAmor]

back to the drawing board!

Note XL2BB:

For the future, it would help greatly if you could give us the sample data in a form that we can copy to test with, rather that a picture.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.



In the example, put what the expected result is and a brief explanation.