Bob, Tom,
Thank You For your answer
the code needs to have ,C20,
C20 is the item wich will be look for in S!$M$5:$M$181

ThankYou



"Bob Phillips" escribió en el mensaje
...
=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)