Sign in to follow this  
MTT

Excel array function help

Recommended Posts

MTT    265
I know this is not exactly the place to ask this, but I am having issues registering with the excelhelp.com forums and on a bit of a deadline. I figure some people here will be pretty familiar with excel, so any help is greatly appreciated.

Here is the array function I am trying to use broken up into components:

=SUM(IF(AND(A4<=$B$14,A5>$B$14),A4,0)) = 11, as it should
=SUM(IF(AND(A5<=$B$14,A6>$B$14),A5,0)) = 0, as it should

Here is the complete array function, not working in the way I would expect:

{=SUM(IF(AND(A4:A5<=$B$14,A5:A6>$B$14),A4:A5,0))} = 0, but I need for it to return 11

Can anybody see what I am doing wrong?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this