Need some help completing this Formula
 

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

have a helper column H316 enter
=month(c316) it will be the month of that cell
copy H316 down upto H 336.
Somewhere type
=countif(H316:H336,"9")
gives you no. of sept accounts
or

=SUMPRODUCT((H316:H336=9)*(G316:G336))

sum of september amounts.



"brigsaz" wrote in
message ...

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