Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
CGI CGI is offline
external usenet poster
 
Posts: 1
Default Counting Ranges

I would like to count a range if all the numbers in that range meet a stated
criteria. For example I have 50 columns (so 50 ranges) and I want to see how
many of these cloumns contain numbers that are all above 75.

e.g. Column 1 has 76, 76, 78, 90 so that would be counted, Column 2 has 77,
76, 94, 83 so that would be counted also, Column 3 has 72, 76, 77, 79 so that
would not be counted and the total would be 2.

Hope that is somehow understandable - I am a bit of a beginner!
 
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 ranges with multiple variables GAIDEN Excel Worksheet Functions 2 October 3rd 08 04:26 PM
counting two ranges for one criteria Jules in IL Excel Worksheet Functions 1 July 15th 08 06:34 PM
counting cells containing certain ranges of dates JRD Excel Worksheet Functions 1 December 12th 07 08:55 AM
Counting cells between ranges Jason30 Excel Discussion (Misc queries) 6 July 24th 06 03:15 AM
Counting ranges, please help SMutchnick Excel Worksheet Functions 5 June 1st 06 07:55 PM


All times are GMT +1. The time now is 03:25 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"