COUNTIF Question

[patrick s.]

I need help with the COUNTIF function. What I'm trying to do is count
range of cells if they are equal to the value of a specific cell
Example: COUNTIF (A1:A20,”=>B1”), but it does not look at what’s in B
it only counts it if the cell value is B1. Does anyone know how t
accomplish this, I would greatly appreciate any help

 

[Frank Kabel]

Hi
siehe Excel.worksheetfunctions

 

[Alan Beban]

I need help with the COUNTIF function. What I'm trying to do is count a
range of cells if they are equal to the value of a specific cell.
Example: COUNTIF (A1:A20,”=>B1”), but it does not look at what’s in B1
it only counts it if the cell value is B1. Does anyone know how to
accomplish this, I would greatly appreciate any help.

=COUNTIF(A1:A4000,">="&B1)

Alan Beban

 

[FPA1869]

I have a large Db of single and double digit numbers and I need
formula
for counting the number of eadh. There are 38 different numbers all i
one coluum. I have only used my Excel as a database and never use
fromuli.
I can find no formula that looks remotely like what I need or even th
way
to enter a formula. <grin> Well, I said that I'm a newbie

 

[Frank Kabel]

Hi
I would use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm