sumif

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 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!
 

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