COUNTIF Question

  • Thread starter Thread starter patrick s.
  • Start date Start date
P

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
 
patrick said:
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.
Click to expand...
=COUNTIF(A1:A4000,">="&B1)

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