the following sumif does not work

=SUMIF($D$10:$D$17,"Cyear",$E$10:$E$17)*-1

A B C D E
Asset Month Day Year (of purchase) Cost


A - D are formated as general
E is formated as ","
B, C, D also use Validation and pick from a list.
Cyear = the current year

The sumif is located in E at the end of the list.


I have a list of assets purchased frmo 1995 thru 2005. At the bottom of
E I have the total cost. Below that i have the sumif formula. i want
it to total all the assets that have a purchase year greater than the
Cyear.

*** Sent via Developersdex http://www.developersdex.com ***