I've been trying for hours to do the following:

I have two columns not next to each other -- i.e. A and F. I want to count how many times the number 1 appears in the same row in both columns.

I've tried various countif and sumproduct formulas but nothing is right. I'm not sure what I'm missing.

Any help appreciated.