Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate mode based on criteria | Excel Worksheet Functions | |||
How do I count frequency based on 2 criteria (including month) | Excel Worksheet Functions | |||
Calculate average based on date and other criteria | Excel Discussion (Misc queries) | |||
evaluate two cells and calculate based on criteria | Excel Worksheet Functions | |||
calculate the sum based on two different criteria | Excel Discussion (Misc queries) |