countif - I want to enter 2 parameters - how?
 

I have a spreadsheet where I want a total if the # is 9 and <20. How do I
write this?

countif - I want to enter 2 parameters - how?
 

Hi,

This will give SUM of value 9 and < 20. Replacing SUMIF with COUNTIF will
give count of entries 9 and < 20

=SUMIF($A$1:$A$50,"9")-SUMIF($A$1:$A$50,"=20")

hth

"NancyP192" wrote:

I have a spreadsheet where I want a total if the # is 9 and <20. How do I
write this?

countif - I want to enter 2 parameters - how?
 

You can use sumproduct something like this

=SUMPRODUCT((A2:A509)*(A2:A50<20))

Here is a link to everything you ever wanted to know about sumproduct. It is
a very useful function...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"NancyP192" wrote:

I have a spreadsheet where I want a total if the # is 9 and <20. How do I
write this?