The only thing I've got to work so far is to have a column running down which says
And then use that column (here it's C) in this formula. Combining the two seems to result in failure, I'm concluding that it must be beyond me.Code:=IF(B1="Yes",1,0)
Obviously you need to press Ctrl+Shift+Enter with the final one because it uses arrays.Code:=SUM(IF(A1:A26="AC42",C1:C26))