View Single Post
 
Old 08-10-2016, 11:21 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

try this in G29 and drag down

=IF(COUNTIF($H29:$Z29,"x")>0,"Incomplete",IF(COUNT IF($H29:$Z29,"")=19,"Complete","Incomplete"))


EDIT: I can't get rid of the space in the second COUNTIF
Reply With Quote