Try something like this:
=SUMPRODUCT((--TEXT(C2:C10,"yyyymm")={200708,200709})*(A2:A10="fi nance")*(B2:B10="nc"))
Is that something you can work with?
--------------------------
Regards,
Ron (XL2003, Win XP)
Microsoft MVP (Excel)
"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
---