Thread: Count items in range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default Count items in range
=SUM(IF(ISTEXT(B6:K300),,IF(ISEMPTY(B6:K300),,IF(A BS(B6:K300)<100,1,))))

This is an array formula therefore should be netered with CTRL+SHIFT
+ENTER
Reply With QuoteReply With Quote