Problem w countif

M

Mallycat

Because you are not using the formula correctly. This function only has
2 arguments, the first is the range, and the second is the criteria

Hence this will count all the 1's in the range

=countif(j2:j20,"1")

Matt
 
G

Guest

ingeman said:
why won't this formula work? =countif(j2:j20,"1",f2:f20<"40")
Click to expand...

Guessing that the formula above represents what you want to do ..
Assuming cols J and F actually contain real numbers
with the possibility of some empty cells within col F,
try instead:
=SUMPRODUCT((J2:J20=1)*(F2:F20<40)*(F2:F20<>""))

---
 

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

Excel Need Countifs Formula Help 0
Prevent duplicate entries in Excel 2000 11
Complicated Formula help please 4
countif using multiple criteria 4
sumproduct 9
Countif 3
Using Countif on multiple columns 1
IF formula, Partial word, SUM function as result 1

Top