One way:

=SUMPRODUCT((B1:B100DATEVALUE("03/01/05"))*(B1:B100<DATEVALUE("04/01/05"))*
A1:A100)

You do realize, that your parameters will *not* sum the entire month of
March.
What you posted (03-01-05), will exclude the first day of the month.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mpiton" wrote in message
...
what is the proper way of entering a formula if you want to sum colum a if
colum b is 03-01-05 but <04-01-05