Roger,
Works great thanks.

Ralph

"Roger Govier" wrote:

Hi Ralph

The formula should be
=SUMPRODUCT(--(C3:C11=DATE(2007,9,1)),--(C3:C11<=DATE(2007,9,30)),
--(A3:A11="finance"),--(B3:B11="NC"))
+SUMPRODUCT(--(C3:C11=DATE(2007,8,1)),--(C3:C11<=DATE(2007,8,31)),
--(A3:A11="finance"),--(B3:B11="NC"))

The first Sumproduct formula needs terminating with it's closing
parenthesis, before having the "+" sign and then the next complete
Sumproduct formula.
You had them both within the overall set of Sumproduct parentheses.
--
Regards
Roger Govier



"Ralph D''Andrea" wrote in message
...
heres my data:
A B C
finance nc 8/3/2007 *
legal vp 7/30/2007
gto nc 4/10/1902
gtb avp 8/31/2007
finance nc 9/5/2007 *
finance nc 9/12/2007 *
ies assoc 8/24/2007
am nc 8/25/2007
tax nc 9/30/2007

HERE'S MY FORMULA:

=SUMPRODUCT(--(C2:C10=DATE(2007,9,1)),--(C2:C10<=DATE(2007,9,30)),--(A2:A10="finance"),--(B2:B10="NC")+SUMPRODUCT(--(C2:C10=DATE(2007,8,1)),--(C2:C10<=DATE(2007,8,31)),--(A2:A10="finance"),--(B2:B10="NC")))


I GET 4, THE ANSWER SHOULD BE 3

Thanks,
Ralph

"Max" wrote:

"Ralph D''Andrea" wrote:
I can't get the syntax correct ..

Believe the suggestion was simply to collapse the 2 sumproducts (in A2
and
C2) into a single cell in D2, like this: sumproduct(...)+sumproduct(...)

Or, you could also collapse it in D2 using SUM, eg:
=sum(sumproduct(...),sumproduct(...))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---