Thread: date sumfi
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonio Atala Antonio Atala is offline
external usenet poster
  
Posts: 4
Default date sumfi
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)


Reply With QuoteReply With Quote