Need some help completing this Formula

B

brigsaz

My sheet looks as follows:

ID# | NAME | SIGNUPDATE | ORDER# | ORDER DATE | BLANK COLUMN | $$AMOUN

I have a formula that will give me the # of new signups by checking th
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 t
update the formula that counts the new signups $$amount but am havin
some trouble adding the YEAR criteria to the formula. The curren
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 an
help.

Thank You
 
Top