View Single Post
  #1   Report Post  
LOU
 
Posts: n/a
Default SUMIF or SUMNPRODUCT Help

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.