Summing Based on Conditions using Array

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I need to sum an array {=sum(a4:a8/b4:b8)} which is based on two conditions,
that the individual cell dates associated with the array range is less than a
specified date and after another specified date. I've tried numerous
formulas without using the and convention, but can't seem to get it to work.
Thanks.
 
Back
Top