View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
S Jackson S Jackson is offline
external usenet poster
 
Posts: 12
Default Referring to a Date in SumIf

I am very new to forumlas/excel. I want a cell to sum C3:C100, if A3:A100
contains an entry for September. cells A3:A100 are formatted as dates:
09/01/2005.

I don't know how to fill in the blank in the following formula to tell the
worksheet to only sum entries for the month of September:

=SUMIF(A3:A100,_________,C3:C100)

How do I refer to "90" in the criteria section of this formula?

TIA
S. Jackson