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
|