I'm having trouble applying this. I tried this and got an error that said
the formula contained an error:

SUMIF((MONTH(A3:A100)=9),C3:C100)

What is wrong here?

S. Jackson

"Don Guillett" wrote in message
...
checksa is a defined name I gave to a range in columna. You may prefer to
use
a2:a200 d2:d200
instead
change the 1 to 9 for sep

--
Don Guillett
SalesAid Software

"S Jackson" wrote in message
...
I'm sorry, but I'm going to need a little more help. I don't
understand.

FYI, column A is formatted mm/dd/yyyy, if that means anything.


"Don Guillett" wrote in message
...
try this one that I use
=SUMPRODUCT((MONTH(ChecksA)=1)*ChecksD)

--
Don Guillett
SalesAid Software

"S Jackson" wrote in message
...
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