| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if/then statements with "counta"
I want to count the number of cells in a column that have a value less than x.
Any tips? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#2
|
|||
|
|||
|
=countif(Column,"<x")
"Patty via OfficeKB.com" wrote: I want to count the number of cells in a column that have a value less than x. Any tips? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#3
|
|||
|
|||
|
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. bj wrote: =countif(Column,"<x") I want to count the number of cells in a column that have a value less than x. Any tips? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#4
|
|||
|
|||
|
Is your range formatted as numbers, or text?
"Patty via OfficeKB.com" wrote in message ... 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. bj wrote: =countif(Column,"<x") I want to count the number of cells in a column that have a value less than x. Any tips? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#5
|
|||
|
|||
|
nevermind - I used sumproduct and it worked. Thanks!
Patty wrote: 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. =countif(Column,"<x") I want to count the number of cells in a column that have a value less than x. Any tips? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200507/1 |
|
#6
|
|||
|
|||
|
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? Lewis Clark wrote: Is your range formatted as numbers, or text? I replaced COLUMN with the range of cells and I replaced X with my value, but [quoted text clipped - 6 lines] than x. Any tips? -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Next w/o For If/Then Loop | Excel Discussion (Misc queries) | |||
| Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
| Nested IF statements | Excel Worksheet Functions | |||
| If/Then statements with images??? | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Linear Mode
