Using Countif on multiple columns

ingeman · Jul 17, 2006

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

Biff · Jul 17, 2006

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

Try this:

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

Biff

Need Formula to "Adjust" to New Column Assignment	3	Jan 20, 2010
Using <= in countifs statement	1	Jan 22, 2018
Countif with a Range of criteria	8	Feb 26, 2009
Finding the weighted average of text that have been given values	1	Apr 22, 2014
=Sumproduct Question	0	Jan 22, 2012
Array Formula Question	6	Mar 9, 2007
combining multiple columns using ", " seperations..	4	Sep 29, 2009
Complex formula assistance please.	4	Jul 14, 2009

Ask a Question