Summing Based on Conditions using Array

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumIF with 2 Conditions 6
Sum of multiple rows, based on date criteria, separate sheets... 0
Getpivotdata and greater than or equal to 2
Summary of data using array formula 1
Finding the average using conditions in a logic function - problem 1
Efficient Array Formula Construction 8
summing based on text conditions 2
Total or Count based on multiple conditions 4

Top