LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Macro for counting within specific constraints

Hi I'm relatively new to macros and looking for some help and/or direction to
an online source for macro development help. I have columns of data and for
one column I would like to count the number of entries that lie within
certain ranges. For example:

YearMo Day Quantity
200101 1 0.1
200101 2 0.13
200101 3 0.25
200101 4 0.38
200101 5 0.18
and so on for my data table

Macro products wanted
#? Number Count < 0.1
#? Number Count =0.1 & <0.2

The macro product I'm looking for in the total count entered in a cell with
a description of the count in an adjacent cell. Thanks for any help you all
can provide.
 
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 Specific Text japc90 Excel Discussion (Misc queries) 2 January 6th 08 08:42 PM
counting cells that contain a specific value Ed Cain New Users to Excel 2 September 4th 06 02:09 PM
macro for 4 constraints in autofilter Gus Excel Discussion (Misc queries) 1 August 4th 05 01:17 PM
counting specific words jen Excel Worksheet Functions 2 June 25th 05 12:46 AM
Counting occurences of a specific day between two dates coal_miner Excel Worksheet Functions 1 April 20th 05 03:37 PM


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