Prev Previous Post   Next Post Next
  #1   Report Post  
jjj
 
Posts: n/a
Default CountIF problem


Hi,

My brain isn't switched on this morning, this may be more straight
forward than I think...

I'm trying to do a Countif function, which only counts those in the
range which are between "0" and "-2". Lets say the range is $A$1 :
$A$50, and contains values between -3.00 and 5.00.

How can i write this countif formula? It doesnt work the way i'm trying
it!

Many thanks in advance

JJJ


--
jjj
------------------------------------------------------------------------
jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424
View this thread: http://www.excelforum.com/showthread...hreadid=471682

 
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 Problem dave Excel Discussion (Misc queries) 3 August 23rd 05 12:36 PM
COUNTIF and automatic type conversion problem joes Excel Discussion (Misc queries) 2 July 25th 05 03:26 PM
COUNTIF and automatic type conversion problem joes Excel Worksheet Functions 2 July 25th 05 03:26 PM
countif problem WYN Excel Discussion (Misc queries) 4 April 25th 05 04:28 PM
problem with countif Cowtoon Excel Worksheet Functions 5 November 10th 04 11:04 PM


All times are GMT +1. The time now is 07:31 PM.

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"