Could someone tell me where I'm going wrong with this formula please? If the condition of "Green" is met in either or both cells, I want it to pull through & add the numbers in adjacent cells (B20, B69 and B78). If the condition "Green" is not met in either cell, I want it to remain blank. However I am getting the VALUE error. It works fine with zero but not "". Can anyone help please?
=IF(B48="Green",B20)+IF(B54="Green",(B69+B78),"")
Bookmarks