Count the number of orders in a given month

W

Wolverine

Hi,

First, I want to thank anyone who is able to help me in advance! I a
working in Office XP (Excel 2002)... latest updates...

I have an excel data sheet where I tally sales... I am trying to coun
the number of orders in a given month. Each order is on a separate ro
and one column is the date it was placed... the date format i
01-01-2003...

I need to count the number of orders placed in

01-2003
02-2003
03-2003

etc... from 2002 to 2004...

I hope this is detailed enough to give an answer
It is set up something like this:

Date Order # Amount

1/17/2003 6430
1/29/2003 6431
2/1/2003 6432

So, what I would be looking to count is that there were 2 orders i
Januar
 
P

Peo Sjoblom

One way

=SUMPRODUCT(--(ISNUMBER(A2:A200)),--(MONTH(A2:A200)=1))

where A2:A200 holds the dates, the above example is for January, for Feb to
Dec it can be shortened to

=SUMPRODUCT(--(MONTH(A2:A20)=2))

for February, the reason is that the first formula will dodge blank cells
and month(blank) returns 1 for
January

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
B

Bob Phillips

Here is how you can count the entries in Jan 2004

=SUMPRODUCT((A1:A20>=(--("2004-01-01")))*(A1:A20<(--("2004-02-01"))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
W

Wolverine

Thanks Guys....

I was able to get Bob's suggestion to work!

I really appreciate the help
 
Top