Summing data "greater than" in an array

[carpediem0114]

Hi, I'm trying to SUM data subject to a "greater than" condition. I'm not using SUMIF because my calculation is not a simple sum and I also need to use an array, which I don't think is possible. My equation was like this:

=SUM(IF(Sheet1!X$8:X$12431>100000,Sheet1!BF$8:BF$12431))

However, it is not returning the correct answer and I cannot figure out why.

Thank you!

 

[philwojo]

I'm not an expert, but I think you need to do your "IF" statement first to check what you want and then do the "SUM" function if you get the response you want from the IF test.

 

[philwojo]

I'm not totally sure what you are wanting based on your first post, but maybe this will work:

[COLOR=#333333]=IF(sum(Sheet1!X$8:X$12431)>100000,sum(Sheet1!BF$8:BF$12431),"Not greater than 100,000")[/COLOR]

That tests if the sum of x8:x12431 is greater than 100,000, if so it then gives you the sum of BF8:BF12431, if not it gives you a message saying "Not greather than 100,000".

Again, not sure if this is what you want it to do or not, but if not post back more details on what you are expecting things to do.