Hi!

His formula should have worked if the date value was a=20
text string. He has it quoted in the formula.

Try this:

=3DSUMPRODUCT(--(TEXT(A1:A4,"mmm yy")=3D"apr 04"),--
(B1:B4=3D"new"),C1:C4)

Biff

-----Original Message-----
Hi
if the month value is not a date but a text value try:
=3DSUMPRODUCT(--(A1:A100=3D"Apr 04"),--
(C1:C100=3D"New"),E1:E100)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"harwookf" schrieb=20
im Newsbeitrag
...
Hi. Can anybody help me with a formula based on two=20
conditions.

I have a spreadsheet with various columns (example=20
shown below).

Month Customer Contract Type Contract Value Yr=20
Value
Apr 04 xxx New =C2=A310,000 =20
=C2=A32,000
Apr 04 xxx Upgrade =C2=A32,000 =20
=C2=A3500
May 04 xxx New =C2=A315,000 =20
=C2=A35,000

I need to be able to total the 'Yr Value' for 'New'=20
contracts in 'Apr
04'.
In the example above, I expect to get =C2=A32,000 for Apr=20
04 and =C2=A35,000
for May 04.
This could be more complicated as the spreadsheet I=20
want to put the
formula
in is different from where the information is.

I have tried various formula with no success. Below is=20
an example of
one
that I have tried.

=3DSUM(IF(('[New Revenue 04_05.xls]New Revenue'!
$A$2:$A$300=3D"Apr
04")*('[New
Revenue 04_05.xls]New Revenue'!$D$2:$D$300=3D"New"),'[New=20
Revenue
04_05.xls]New
Revenue'!$K$2:$K$300))

Thanks.

.