Hello all,
I am trying to set up a sheet where I can add values from columns if they are positive and ignore them if they are negative. This is what I wrote:
=IF(and(J2>0,F2>0,B3>0),J2+F2+B3,if(and(J2>0,F2>0,B3<0),J2+F2,if(and(J2>0,F2<0,B3>0),J2+B3,if(and(j2>0,F2<0,B3<0),J2,if(and(J2<0,F2>0,B3>0),F2+B3,if(and(J2<0,F2<0,B3>0),B3,if(and(J2<0,F2>0,B3<0),F2))))))0)
It's quite messy and it doesn't actually work. Is there a way to fix it? or maybe a cleaner way of doing this?
Thanks!!!
FYI the equation just contains all outcomes of the individual results of flipping three coins essentially.
It appears that you simply want the sum of any positive values in those three cells.
This will work
If they were in a continuous range you could try this (providing there were no other values in cells in that range
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Crooza; 11-06-2014 at 08:15 PM.
Happy with my advice? Click on the * reputation button below
YES! Exactly that. Thank you for your help!
Great . Glad it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks