Countif

  • 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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Combining Percent with Text 5
Multi-demensional frequency distribution 4
Please help with countif formula 4
Counting Problem 2
Excel Copy COUNTIF while retaining reference 7
COUNTIF on result of formula 4
countif, multiple value range PLEASE HELP 2

Back
Top