formulas-
 

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

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

Alternatively:

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


In article ,
mpiton wrote:

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