Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 15th 08, 10:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 2
Default COUNTIF a cell value is between two numbers

I have a range of cells (D$9350) and I want to count the number of
instances that a number in the cell range is between 100 and 400. I keep
getting errors.

  #2   Report Post  
Old August 15th 08, 10:25 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default COUNTIF a cell value is between two numbers

One way:

This also counts 100 and 400.

=COUNTIF(D9350,"=100")-COUNTIF(D9350,"400")

--
Biff
Microsoft Excel MVP


"LAWNDALE" wrote in message
...
I have a range of cells (D$9350) and I want to count the number of
instances that a number in the cell range is between 100 and 400. I keep
getting errors.



  #3   Report Post  
Old August 15th 08, 10:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
Posts: 2
Default COUNTIF a cell value is between two numbers

Very helpful. Thanks.

"LAWNDALE" wrote:

I have a range of cells (D$9350) and I want to count the number of
instances that a number in the cell range is between 100 and 400. I keep
getting errors.

  #4   Report Post  
Old August 15th 08, 11:47 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default COUNTIF a cell value is between two numbers

You're welcome!

--
Biff
Microsoft Excel MVP


"LAWNDALE" wrote in message
...
Very helpful. Thanks.

"LAWNDALE" wrote:

I have a range of cells (D$9350) and I want to count the number of
instances that a number in the cell range is between 100 and 400. I keep
getting errors.





Reply
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
Countif numbers fall between two values Chris Excel Worksheet Functions 4 July 24th 08 02:28 PM
countif colored numbers Mark Excel Worksheet Functions 2 May 22nd 08 09:12 AM
COUNTIF for range of numbers bimseun Excel Discussion (Misc queries) 3 January 24th 06 03:40 PM
Using COUNTIF to find numbers within a range greater than the mean Lowkey Excel Worksheet Functions 2 May 17th 05 06:34 PM
Countif for numbers between x and y don Excel Worksheet Functions 4 May 5th 05 01:01 PM


All times are GMT +1. The time now is 10:38 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017