Conditional Frequency?

[bp32]

Hi all,

I am trying to create a series of frequency tables but have data that spans multiple years. I would like the tables calculated, but for each year separately.

Is there a way to write a formula for a conditional frequency? So that the frequency is only calculated for those rows where the year is equal to what I specify?

Thanks.

 

[T. Valko]

Hi all,

I am trying to create a series of frequency tables but have data that spans multiple years. I would like the tables calculated, but for each year separately.

Is there a way to write a formula for a conditional frequency? So that the frequency is only calculated for those rows where the year is equal to what I specify?

Thanks.

Maybe something like this...

Book1
	A	B
2	6/5/2010	30
3	10/3/2010	87
4	6/26/2010	34
5	9/20/2014	11
6	8/26/2010	77
7	7/30/2006	34
8	8/9/2010	30
9	7/24/2010	73
10	8/30/2009	16
11	4/23/2014	79
12	8/10/2006	50
13	7/27/2010	12
14	10/14/2008	75
15	7/25/2010	72
Sheet1

Count numbers that are >=50 that correspond to year 2010.

=SUMPRODUCT(--(YEAR(A2:A15)=2010),--(B2:B15>=50))

 

[bp32]

Thanks! I think I can use a reference rather than the number in the second part of the formula to make this easier, since I have a mess load of bins.

 

[T. Valko]

Thanks! I think I can use a reference rather than the number in the second part of the formula to make this easier, since I have a mess load of bins.

You're welcome. Thanks for the feedback!