Count Ranges Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

Seanie

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
 
=SUM(IF((ISBLANK(K10:K22))*(J10:J22<>0),1,0))

CTRL+SHIFT+ENTER this formula as it is an array-formula
 
Back
Top