Hi

=SUMPRODUCT(--(Type="NEW"),--(StartDate<=$B$6),RentMth)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"James T" wrote in message
...
After reading a few websites I find that SUMIF won't cut it for multiple
critera. However it appears SUMPRODUCT may do it, but unsure how I
achieve
what I need with SUMPRODUCT.

Below is the actual table I have in my excel sheet.

I would like to sum the column RENT/MTH (which is a calculated field
RENT/WK
* 4) if the TYPE = NEW and also if the START DATE is <= to a date in
another
field (lets us say in field B6).

Pay/Wk Pay/Mth Rent/Wk Rent/Mth Start Date Type
$200.00 $866.66 $106.00 $459.33 31/08/2005 NEW
$210.00 $909.99 $138.00 $598.00 31/08/2005 OLD
$200.00 $866.66 $167.00 $723.66 31/08/2005 BEST

Can someone help with development of the formula?

Thanks in advance.

James