Using Countif on multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40"))
 
ingeman said:
Why doesn't the following formula work?
=count(if(k2:k20,"1",j2:j20,"<40"))
Click to expand...

Try this:

=SUMPRODUCT(--(K2:K20=1),--(J2:J20<40))

Biff
 
You must log in or register to reply here.

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

Need Formula to "Adjust" to New Column Assignment 3
URGENT HELP - SUM FORMULA 5
formula correction 4
Countif with a Range of criteria 8
Array Formula Question 6
combining multiple columns using ", " seperations.. 4
Complex formula assistance please. 4
Problem w countif 2

Back
Top