When I change it to IF(AND(, I get a #VALUE! result.....
=IF(AND(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY, HH:MM:SS"), IF(COUNTIFS(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY, HH:MM:SS"),"MM/DD/YYYY HH:MM:SS","NONE"))
I am trying to get Excel to return the Training #, Date, Time of the assigned training.
Bookmarks