Countif Help

  • Thread starter Thread starter Tusnal
  • Start date Start date
T

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
 
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
 
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
 
Back
Top