Thread: count closest empty cells in a row
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Xxer Xxes Xxer Xxes is offline
external usenet poster
  
Posts: 33
Default count closest empty cells in a row
=COUNTBLANK(OFFSET($A11,,,,SUMPRODUCT(MAX((A11:C R11<"")*COLUMN(A:CR)))))

It works very well for me ; thank you very much for
your assistence , Sir !
Reply With QuoteReply With Quote