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