I’m getting the “Formula Omits Adjacent Cells” warning for the following formula on some cells but not others; however everything is working as it should. Why is excel complaining about omitted adjacent cells? It all looks good to me.
=IF(COUNTBLANK(C$1:E$1)=3,0,IF((C$1*C10=1)+(E$1*E10=1),0,1))
I have attached the file I am working on with the hidden rows unhidden so you can see whats going on. It is a weekly football picks spreadsheet that allows you to mark a 1 above the winning teams to get the number of incorrect picks in the left column. If no 1 marks the winning team then the above formula should count the blanks total for that team as 3 and simply assign a 0 incorrect picks for that game. If there is a 1, then the main if formula will tabulate a correct or incorrect pick accordingly.
Bookmarks