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