I have a workbook with several worksheets that is fed data from Access (via a
worksheet in the workbook called "rawdata".

I have a formula (shown below) that worked when the worksheet didn't import
the Access data, but doesn't work after the Access import. After the import,
F7=2 and only EZ7 and FA7 has data (all data are dates). The blank cells
show "=rawdata cell#" when clicked on. I've tried changing "sum" to count,
counta, but the cell continues to show "GO". Is there a way to correct this
formula in excel so the cell will show "NO GO" if the criteria isn't met?

=IF(AND(F7=1,SUM(EW7,EZ7,FA7,FD7)=3),"GO",IF(AND( F7=2,SUM(EW7,EZ7,FA7,FC7,FD7)=4),"GO",IF(AND(F7=3 ,(SUM(EZ7,FA7,FD7,GA7,GB7,GC7)=5)),"GO","NO GO")))

I hope I explained this where it makes sense.

Appreciate anyones help on this.