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

M

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! - [email protected]
 
T

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.
 
Top