sumif or sumproduct multiple conditions

J

joe@malvern

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top