OK, just change 2005 to C20.

--

HTH

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


"Antonyo" wrote in message
...
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)