Multiple Countif parameters

[Sandgroper]

Hello, have searched unsuccesfully, so will post in hope

I want to count occurrances weekly of the number of times a number appears.

e.g.

1/08/2007 2010
2/08/2007 5160
3/08/2007 2010
4/08/2007 5160
5/08/2007 2222
6/08/2007 2222
7/08/2007 2010
8/08/2007 2010
9/08/2007 2010
10/08/2007 2222
11/08/2007 5160
12/08/2007 5160
13/08/2007 2010
14/08/2007 2010

so week 1 would return result of 3 for 2010 and week two would be 4 occurances. Working with dates is confusing !!!

So far I have :

=COUNTIF(B1:B14,"2010")+(COUNTIF(A1:A14,">=""01/08/2007")-(COUNTIF(A1:A14,"<=""07/08/2007")))

but only returns the number 7

Or an alternative solution would be nice too

TIA

 

[Domenic]

Try...

=SUMPRODUCT(--(B1:B14=2010),--(A1:A14>="01/08/2007"+0),--(A1:A14<="07/08/2007"+0))

Hope this helps!

 

[Sandgroper]

Thank you .. is perfect !!!

I searched for the last two days in frustration... I appreciate your help !!!