Re: Multiple conditions with COUNTIF function

From: Aladin Akyurek (akyurek_at_xs4all.nl)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 05:54:59 +0200

I thrust Location and Data are defined by means of dynamic formulas. If this
is done correctly, the size of Location and that of Data should be equal...

=SUMPRODUCT(--(Location=E2),--(Date>=F2),--(Date<=G2))

where E2 houses a department of interest like Administration, F2 a true date
like 1-Jun-04, and G2 31-Jun-04 or a formula like:

=DATE(YEAR(F2),MONTH(F2)+1,0)

"Jenny" <jayjay_3@hotmail.com> wrote in message
news:62f401c4751c$ef1373a0$a401280a@phx.gbl...
> I have a large database of work orders. I need to find
> the number of entries that are from particular
> departments (1st condition) and from a particular month
> (2nd condition). My date column is in the format 15-Jun-
> 04. I am currently using it on Windows XP(at home) but
> work only has (Windows 97), which is where it will need
> to be eventually run. The database also needs to be
> continuous as entries will continue to be put in over a
> long period of time.
>
> I have tried the following but I keep coming up with
> various errors (different every time):
>
> =SUM(IF(Location="Administration",IF(Date<"1-Jun-04",IF
> (Date>"31-Jun-04",1,0)
>
>