formulas-

[Guest]

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

 

[Ragdyer]

One way:

=SUMPRODUCT((B1:B100>DATEVALUE("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.

 

[JE McGimpsey]

Alternatively:

=SUMIF(A:A,">3/1/05",B:B) - SUMIF(A:A,">=4/1/05",B:B)