Thread: Count Ranges Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default Count Ranges Q

How could I create a formula that will add up all the instances in
K10:K22 which are <blank if a not zero value is entered in the
corresponding cells in J10:J22

eg. If J10 = <blank, then my answer would be 0
eg if J10 = 123 and J19 = 123 and K10 = <blank and K19 = Mon, then my
answer would be 1