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

Count Ranges Q
 

=SUM(IF((ISBLANK(K10:K22))*(J10:J22<0),1,0))

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


On 15 Sty, 16:43, Seanie wrote:
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

Count Ranges Q
 

=SUMPRODUCT(--(K10:K22=""),--(J10:J22<0))

--
__________________________________
HTH

Bob

"Seanie" wrote in message
...
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