PC Review


Reply
Thread Tools Rate Thread

=COUNTIF(A5:A51,"=D240:Q251") Why will the cell D220 not TOTAL

 
 
Terry
Guest
Posts: n/a
 
      24th Nov 2007
I am having problems matching a range of number in the above cell range
 
Reply With Quote
 
 
 
 
Mike H
Guest
Posts: n/a
 
      24th Nov 2007
Terry,

Write down what you are trying to do and I'm sure someone can help.

Mike

"Terry" wrote:

> I am having problems matching a range of number in the above cell range

 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      24th Nov 2007
Try:
=COUNTIF(A5:A51, "="&D240:Q251)

"Terry" wrote:

> I am having problems matching a range of number in the above cell range

 
Reply With Quote
 
JLGWhiz
Guest
Posts: n/a
 
      24th Nov 2007
I am not so sure about your criteria. It might draw an error.

"Terry" wrote:

> I am having problems matching a range of number in the above cell range

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" bony_tony Microsoft Excel Worksheet Functions 1 5th Jul 2010 07:04 AM
VBA Syntax for Countif condition where only 1st char in Range of each cell = "M" EagleOne@discussions.microsoft.com Microsoft Excel Programming 5 7th Oct 2009 07:19 PM
=countif (h3:h16">=01 01 2006") how to substitute cell for date =?Utf-8?B?QmFycnk=?= Microsoft Excel Worksheet Functions 4 14th Jan 2006 12:35 AM
Linking two "total" pages to create a "Complete Total" page =?Utf-8?B?Sm9yZG9u?= Microsoft Excel Worksheet Functions 0 10th Jan 2006 11:18 PM
=+COUNTIF(D10:D240,"Yes") NOT WORKING Helder Microsoft Excel Misc 3 5th Sep 2003 12:07 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:58 AM.