I am trying to add values from one column (H) if the date year in
another (E) is 2006 or similar. I have tried the following with a 0 as
the result (which is wrong).

={SUM(IF($E$7:$E$10070=(YEAR($E$7:$E$10070)=2006), $H$7:$H$10070))}

Any ideas as to what is wrong? I suspect the =(YEAR($E$7:$E$10070)=2006
section of the formula.


--
OSDavidL
------------------------------------------------------------------------
OSDavidL's Profile: http://www.excelforum.com/member.php...o&userid=31305
View this thread: http://www.excelforum.com/showthread...hreadid=509961