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

How to use vlookup in an array formula 2
Automation of scanned file storage based on content 0
Autofiller Tool Help 4
sum based on value in a range 0
summing based on text conditions 2
Summary of data using array formula 1
Select random records by two conditions 1
Getpivotdata and greater than or equal to 2

Top