View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jamie Jamie is offline
external usenet poster
 
Posts: 191
Default Summing Based on Conditions using Array

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.