Hello,
I'm trying to add 4 figures together from different columns. The first 2 columns have values £5 and £15. The second 2 columns have £0 values. Column 5 is where I want all four columns to be added together but only if either of the last two columns are greater than £0. So column 5 would display £0 unless either column 3 or 4 are populated with a figure. I've tried multiple formulas but don't seem to be able to get anything that works.
I would really appreciate your help.
Many thanks,
Clio
Its much easier if you add a workbook rather than a picture as we dont have to try and recreate the data
Try =IF(OR(M1>0,N1>0),SUM(K1:N1),0)
Thanks ever so much! That's worked straight away!
I'll heed your advice for next time I have a problem and get a workbook created.
Thanks again 🙂
