Check your Wiindows Regional Settings (in Control Panel).
--
David Biddulph

"Cassidy1" wrote in message
...
Hi Max, since you helped me with this calculation, I have gotten a new
computer and had all my programs and documents etc copied over to it. For
some reason, in excel, all my date formats were changed from dd/mm/yyyy to
mm/dd/yyyy and my date calculations are not working now. I have gone in
to
"format cells" and set the format to custom which changed my date fields
back
to dd/mm/yyyy, but my calculations still don't work.

"Max" wrote:

Assuming referral dates in col J (dates are assumed real dates),
areas in col K (V, S etc),
you could try something like this:
=SUMPRODUCT((TEXT(J2:J147,"mmmyy")="Mar08")*(K2:K1 47="V"))
to return the referrals in Mar08 for area V
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cassidy1" wrote:
Hi,
I have an excel spreadsheet that contains info on referrals; date
received,
area received, client file number etc.
I need to figure out how to track monthly referrals by area.
I already have a column that calculates total referrals each month that
looks like this: =COUNTIF(J2:J147,"31/03/2008") and this works great,
but I
have another column that shows the area referred: V for Victoria or S
for
Sidney and I want to know how many referrals I received each month for
each
area, so any help on how I would formulate that?

Thanks