My sheet looks as follows:
ID# | NAME | SIGNUPDATE | ORDER# | ORDER DATE | BLANK COLUMN | $$AMOUNT
I have a formula that will give me the # of new signups by checking the
signup date that looks like this:
=SUMPRODUCT(--(YEAR(C316:C336)=2005),--(MONTH(C316:C336)=9))
I adjust the year and month values for new months and years. I need to
update the formula that counts the new signups $$amount but am having
some trouble adding the YEAR criteria to the formula. The current
formula looks like this:
=SUMPRODUCT((--(MONTH(C285:C312)=8))*(G285:G312))
I have tried this:
=SUMPRODUCT(--(YEAR(C285:C312)=2005),--(MONTH(C285:C312)=8))*(G285:G312)
and get the #value! error.
I have tried this:
*=SUMPRODUCT((--(YEAR(C285:C312)=2005),--(MONTH(C285:C312)=8))*(G285:G312))*
and it will not accept this formula.
Can someone show me what I am doing wrong? I would appreciate any
help.
Thank You.
--
brigsaz
------------------------------------------------------------------------
brigsaz's Profile:
http://www.excelforum.com/member.php...o&userid=27478
View this thread:
http://www.excelforum.com/showthread...hreadid=469880