Help with a 'simple' (prob!!) formular

[meepmeep]

I have date figures in A col and sales amounts in B - i want to identify
trends. I want to formulate this;

if a sales was between 1st and last day of month x and between £3001
and £4000 count 1 ie i want to be able to see how many sales between
two figures and two dates there were

i am really stuck on this one! - (e-mail address removed)

 

[Intruder9]

I sent you a file that should accomplish what you are trying to do.

 

[Tom Ogilvy]

=sumproduct((Month(A1:A200)=9)*(B1:B200>=3001)*(B1:B200<=4000))

9 is September

assumes no blank cells in the date column, column A.