P
Patty via OfficeKB.com
I want to count the number of cells in a column that have a value less than x.
Any tips?
Any tips?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bj
=countif(Column,"<x")
P
Patty via OfficeKB.com
I replaced COLUMN with the range of cells and I replaced X with my value, but
it didn't work. It returned a 0, when I know I have 9 cells that are less
than x.
it didn't work. It returned a 0, when I know I have 9 cells that are less
than x.
L
Lewis Clark
Is your range formatted as numbers, or text?
Patty via OfficeKB.com said:I replaced COLUMN with the range of cells and I replaced X with my value,
but
it didn't work. It returned a 0, when I know I have 9 cells that are less
than x.
P
Patty via OfficeKB.com
nevermind - I used sumproduct and it worked. Thanks!
P
Patty via OfficeKB.com
My range is formatted as numbers, but the range is actually formulas linked
in from another cell. Could that be the issue with "countif?"
Now I want to count the cells that have values between two ranges. How do I
do that?
in from another cell. Could that be the issue with "countif?"
Now I want to count the cells that have values between two ranges. How do I
do that?
Lewis said:Is your range formatted as numbers, or text?
[quoted text clipped - 6 lines]I replaced COLUMN with the range of cells and I replaced X with my value,
but