LinkBack URL
About LinkBacks
Does this work for you for cell AJ172?
=MAX(0,MIN(J172,AI172)-MAX(I172,AH172)+1)*(COUNT(I172:J172,AH172:AI172)=4)
Does this work for you for cell AJ172?
=MAX(0,MIN(J172,AI172)-MAX(I172,AH172)+1)*(COUNT(I172:J172,AH172:AI172)=4)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks