Multiple Aurguments in countif statement

[Barry H]

I need to know how to put multiple aurguments in the
countif statement. I want to look at a range of aging
days and count everything >0 and <30 days.

Any thoughts?

 

[Dave R.]

Yes-
If you want to use countif statement(s); you can countif your range >0 MINUS
countif your range <30 .
This will count values from 1-29 .

 

[barry]

Is there a better way to do this?

-----Original Message-----
Yes-
If you want to use countif statement(s); you can countif your range >0 MINUS
countif your range <30 .
This will count values from 1-29 .






.

 

[Barry]

I believe this would just net to 0, right?

-----Original Message-----
Yes-
If you want to use countif statement(s); you can countif your range >0 MINUS
countif your range <30 .
This will count values from 1-29 .






.

 

[Dave R.]

It will not net 0 if theres any number between 1 and 29 in the range.

countif(a1:a100,">0")-countif(a1:a100,"<30")

first statement counts all positive numbers. second statement subtracts
those over 30.
assuming you have numbers between 1 and 29 in the range a1:a100, this will
count those.

 

[Guest]

Yes, got it, thanks for the help. Second statement should
be ">30"...

 

[Dave R.]

Oh yehp! thats what I get for not trying it in Excel first!