( by Alex Vaughan )
Have a look at the following screenshot of my spreadsheet:
As we have Major's in Column B, D, F and G, so we have to count "No" in these columns.
So, I have inserted following formula in Cell H1:
=arrayformula(if(row(A:A)=1;"Count Major No's";if(row(A:A)=2;"";if(A:A="";"";(B:B="No")+(D:D="No")+(F:F="No")+(G:G="No")))))
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.