Hi,

=SUM(('2004'!$R$3:$R$998='jk')*(MONTH('2004'!$P$3: $P$998)=1)*(YEAR('2004'!$P$3:$P$998)=2004)+('2004' !$T$3:$T$998='jk')*(MONTH('2004'!$S$3:$S$998)=1)*( YEAR('2004'!$S$3:$S$998)=2004))

- Asser


--
Jazzer
------------------------------------------------------------------------
Jazzer's Profile: http://www.excelforum.com/member.php...fo&userid=4464
View this thread: http://www.excelforum.com/showthread...hreadid=277681