Hi
try:
=SUMIF(B1:B300,"=" & DATE(2004,10,1), F1:F300) -SUMIF(B1:B300,"=" &
DATE(2004,11,1), F1:F300)
"LOU" wrote:
Hello!
how do I write this one?
B1 thru B300 has date values
F1 thru F300 has the dollar values
I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.
|