I’m sorry if this as been answered somewhere else but I’ve been looking seemingly everywhere for an answer!

I’m trying to work out a sumif formula where if there’s a value in a cell it’ll take that value but if there isn’t it’ll take the value from another cell.

For example, if there’s numbers in cell E1 and K1 (there will always be values in E1) I want the sumif formula to take whatever value is in K1 if there isn’t a value in K1 I want to formula to take the value from E1.

Sorry for such a convoluted explanation – any help will be greatly appreciated!!

By: Carl Hodgson