=SUMPRODUCT(--(YEAR(S!$M$5:$M$181)=2005),S!$D$5:$D$181)

and

=SUMPRODUCT(--(YEAR(S!$M$4:$M$103)=2005))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Antonio Atala" wrote in message
...
How do I add to this formula to look only for year 2005


=SUMIF(S!$M$5:$M$181,C20,S!$D$5:$D$181)

=COUNTIF(S!$M$4:$M$1003,C20)