Count Ranges Q

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
 
J

Jarek Kujawa

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation - Complex Q 2
Help with formula 3
Sum with a Twist Q 2
VBA concatenate ranges into a new document 0
Adding to a formula thru out a worksheet 2
Excel formulae to VBA functions 5
Conditional format order priority 2
Mail Merge Switch - Dollars to Words 0

Top