Thread
: [Solved]
Formula for Complete/Incomplete
View Single Post
08-10-2016, 11:21 AM
NoSparks
Windows 7 64bit
Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
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
NoSparks
View Public Profile
Find all posts by NoSparks