I need some help using conditional sumif function (have excel 2003 so
sumproduct?)
collecting sales data to use as a forecasting tool (using several data entry
drop down menus for 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 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 and I would like to combine their functionality
so that active quotes (not "dead" represented by N range), 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 to
sum)

thanks in advance for any help!