Need an equation which can be applied to a column.
Basic equation is =IF H1="yes",0,1
It only applies to one cell but I need to make it refer to the whole column.
So IF H1,H2,H3 H4 etc = "yes",0,1. However I don't know how to express this mathematicallly
Solved by M. F. in 24 mins