Counting instances of a certain number in Excel

[saadabc]

Is there a script that lets you count the instances of a certain number on a given row in Excel. The script can be in any language - C, C++, VB, VBScript etc ...

 

[AnotherHiggins]

Excel has the function built in. Have a look at COUNTIF.

Example:
=countif(2:2,a1)

To get VBA code, just turn on macro recorder.

[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[saadabc]

I'm using =COUNTIF(A14:BH14,"*") to count number of asterisks in the 14th row - =COUNTIF(A15:BH15,"*") for number of asterisks in 15th row - but it is giving me the wrong number. Example, the number of asterisks in the 14th row is 10, but it is giving me 59 , number of asterisks in the 15th row is 9, but is giving me 59. It is giving me 59 for all rows. Data is the sheet may look like this - 5<6* , 9=5* .. i want to count the number of cells that have data that contains an asterisk.

what am i doing wrong in the formula..

 

[KenWright]

See your other post for a solution

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------