Multiple Aurguments in countif statement

  • Thread starter Thread starter Barry H
  • Start date Start date
B

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?
 
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 .
 
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 .






.
Click to expand...
 
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 .






.
Click to expand...
 
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.
 
Back
Top