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

  • Thread starter Thread starter meepmeep
  • Start date Start date
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! - (e-mail address removed)
 
=sumproduct((Month(A1:A200)=9)*(B1:B200>=3001)*(B1:B200<=4000))

9 is September

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