You could use one of these.

=SUM(IF(YEAR('Car Inventory'!K2:K431)=2000,'Car Inventory'!G2:G431,0))

Which is an array formula so commit with Ctrl-Shift-Enter.

Or if you don't want to use an array formula then:

=SUMPRODUCT((YEAR('Car Inventory'!K2:K431)=2000)*('Car
Inventory'!G2:G431))

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=554664