Most RecentMost ViewedMost LikesAdd 5 if a cell contains text "yes" Hi all Is this possible?. I would like to add several cells together then add "5" to the total if one cell contains the text 'yes'. I have so far =SUM(B1,C1,D1,E1) please help thanks Solved
