Countif

[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
see Excel.worksheetfunctions

 

[Guest]

your formula should look like this:

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

note: the '&' ampersand concantenates the expression ">=" with the cell
reference B1 and must be outside of the quotes.

HTH

swatsp0p