Countif Help

[Tusnal]

Hi

i am trying to countif letters like "@" .... i was thinking in a range
... but it doesnt support vars......... so what can i do ??? i was
trying something like this countif(rows,cols;="@") rows and cols are
integers .... but it doesnt work


thx for the help

Tusnal

 

[Bernie Deitrick]

Tusnal,

A COUNTIF formula, used like

=COUNTIF(A1:C10,"@")

will work, as long as you are looking for cells that have only the
single character @ in them. If you want to find how many have the
character @ as part of a string, then use

=SUMPRODUCT(NOT(ISERROR(FIND("@",A1:C10)))*1)

HTH,
Bernie
MS Excel MVP

 

[Tusnal]

The problem with that is........ i dont know when the cells overs

it will be something like .cells(1,1), .cells(Longest1,Longest2)
where Longests are integers that is the problem....... but i can
use any vars.....

i need something that counts "@" but it have to read the range fro
vars...... that is the problem

Thx For the help ........... Tusna

 

[Tusnal]

FINALLY!!!

i was searching in google and i found the solution.......

Worksheets("Blah").Cells(54, 1).Formula = "=COUNTIF(" & Range(Cells(1
1), Cells(10, 1)).Address & ", ""@"")"

this seems to work!!!

i got it from here ...
http://www.herber.de/forum/archiv/8to12/t8828.htm

thx to Hans

Tusna