• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sumif driving me crazy

M

MGCummins

New Member
Hi - I thought this was a simple query, but it's driving me crazy - I want to use the sumif function where I only want to add to total of a cell if the figure is negative - I think I may be getting my range wrong.

I have a cell which has a normal autosum in it - I then have a column with a second autosum. I want to create another cell, where the results will show the autosum of the first cell minus the second autosum, but only if this second autosum has a negative answer.

I was entering =sumif(C17+E15, "<0") any help would be gratefully received :-)
 
Array Formula:

=SUM(IF(OR(C17<0,E15<0),C17+E15))

Dont forget to press CTRL-SHIFT-ENTER button together
 
thank you sooooo much, that worked perfectly xx I will now have to go and read the formula to try and understand what you did!
 
azumi said:
Array Formula:

=SUM(IF(OR(C17<0,E15<0),C17+E15))

Dont forget to press CTRL-SHIFT-ENTER button together
Click to expand...

I really don't see the need for an array formula.= IF(OR(C17<0,E15<0),C17+E15,"") does the trick nice and easy
 
You must log in or register to reply here.
Back
Top