sumif
 

I need some help using conditional sumif function (have excel 2003 so
sumproduct?)
collecting sales data to use as a forecasting tool (using drop down menus
for several data entry columns, territory, primary industry, secondary
industry, quote date, expected close date, quote $'s, with purchase
information on the same row once a customer orders).

I would like to add the outstanding/open quote$'s by month excluding quotes
that have been identified as "dead" and prospects that have been converted to
customers.

=SUMIF(N3:N299,"<dead",M3:M299)-SUMIF(P3:P299,"0",M3:M299)

=SUMIF(K3:K299,"=01/01/09",M3:M299)-SUMIF(K3:K299,"=01/31/09",M3:M299)

the two formulas above work independently and I would like to combine their
functionality so that active quotes (not "dead"), where the prospect has not
purchased yet (P range represents purchase date "0"), and do this by month
(k range represents the quote date)(m range represents the quote $'s)

thanks in advance for any help!