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
|