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(P3299,">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!
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(P3299,">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!