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: 27
Default Calculate FREQUENCY based on criteria...

Hi there -
Stumped on this one... I want to calculate frequency for items that
meet a certain criteria. In this case, date. I have a bunch of data that
looks like this:

COL-A | COL-B
1/2/09 | 10
1/6/09 | 13
1/8/09 | 10
10/23/08 | 10
2/3/09 | 10
2/9/09 | 10

I want to calculate the FREQUENCY of COL-B data for items that occur in
2009. In the example above, that would be 4 for "10" and 1 for "13".

I'm using this data to create a frequency distribution graph.

thanks in advance!
-meat
 
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
Calculate mode based on criteria goofy11 Excel Worksheet Functions 1 November 27th 06 09:55 PM
How do I count frequency based on 2 criteria (including month) RS Excel Worksheet Functions 18 November 24th 06 12:02 PM
Calculate average based on date and other criteria Kycajun Excel Discussion (Misc queries) 3 July 14th 06 10:08 PM
evaluate two cells and calculate based on criteria galiant Excel Worksheet Functions 6 July 10th 06 04:21 PM
calculate the sum based on two different criteria Ken Excel Discussion (Misc queries) 1 May 22nd 05 09:58 AM


All times are GMT +1. The time now is 06:24 AM.

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"