LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Counting Problem

I am trying to count all the numbers in a column that equal or exceed a
number that is entered manually in an individual cell (A1). But the countif
function does not work unless I enter the number directly into the formula.
For example:

Assume there is the number 5 in cell A1. I want to count how many cells in
range A4:A20 contain a number equal to or greater than the number in cell A1.
When I enter the following formula in Cell A21 it returns "0" even though
there are some cells in the column A4:A20 that contain a number equal to or
greater than 5.

The formula I enter in cell A21 is:

countif(A4:a20,"=A1")

This formula does not work unless I replace the cell reference "A1" with the
number I am using as the hurdle number - in this case the number is 5.

Is there some way to count the numbers in a column by making the count
function use a number in a defined cell as the hurdle number?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting problem vito Excel Worksheet Functions 3 August 11th 07 08:19 PM
Counting Problem Becks Excel Discussion (Misc queries) 4 May 11th 06 09:38 AM
Counting problem daydreamin7 Excel Discussion (Misc queries) 7 March 1st 06 06:30 PM
Counting Problem peter_rivera Excel Discussion (Misc queries) 1 September 16th 05 09:19 PM
counting problem philip Excel Worksheet Functions 2 August 5th 05 12:47 AM


All times are GMT +1. The time now is 01:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"