#1   Report Post  
Old December 1st 04, 02:35 PM
Alex
 
Posts: n/a
Default Countif Between

I need to count how many cells in column D have a value in them between 7 and
3.
I cant find anything that lets me use between as criteria and Countif only
allows me to have 1 criteria.

Any ideas?

  #2   Report Post  
Old December 1st 04, 03:01 PM
Jason Morin
 
Posts: n/a
Default

Here are 3 possible ways (inclusive):

=COUNTIF(D1100,"=3")-COUNTIF(D1100,"7")
=SUMPRODUCT(--(D1100=3),--(D1100<=7))
=COUNT(D1100)-SUM(COUNTIF(D1100,{"<3","7"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
I need to count how many cells in column D have a value

in them between 7 and
3.
I cant find anything that lets me use between as

criteria and Countif only
allows me to have 1 criteria.

Any ideas?
.

  #3   Report Post  
Old December 1st 04, 03:06 PM
JulieD
 
Posts: n/a
Default

Hi Alex

here's two methods
=SUMPRODUCT(--(D3353),--(D335<7))
=COUNTIF(D335,""&3)-COUNTIF(D335,""&6)

Cheers
JulieD

"Alex" wrote in message
...
I need to count how many cells in column D have a value in them between 7
and
3.
I cant find anything that lets me use between as criteria and Countif only
allows me to have 1 criteria.

Any ideas?





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
Subtotal And Countif Sheryl Excel Discussion (Misc queries) 4 December 9th 04 07:18 PM
Countif bjg Excel Worksheet Functions 11 November 27th 04 03:32 PM
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM
Countif ??? terryv Excel Worksheet Functions 2 November 8th 04 09:03 AM
countif, again Liz G Excel Worksheet Functions 2 November 1st 04 11:20 PM


All times are GMT +1. The time now is 06:16 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017