Hi guys. I'm looking for a bit of Excel advice. I have the three columns below and what I want is to try and calculate the total outstanding. So basically if column K is TRUE and column L is FALSE then I want to get the value in column H. Ideally I'd like to do this all in one cell to avoid an extra column (I've been trying to get the SUMIF function to do it but, alas, to no avail!) but I don't mind having an extra column if one's needed. So. Any Excel guru's with any bright ideas out there? The spotlight's on you!