Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
I would like to count how many cells only IF they contain a value
greater than 1. Is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
=COUNT(A1:A123,"1")
Adjust range to suit. Gord Dibben MS Excel MVP On Tue, 25 Mar 2008 12:43:22 -0700 (PDT), tonyalt3 wrote: I would like to count how many cells only IF they contain a value greater than 1. Is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
If your cells are in column A, then try this:
=COUNTIF(A:A,"1") Hope this helps. Pete On Mar 25, 7:43*pm, tonyalt3 wrote: I would like to count how many cells only IF they contain a value greater than 1. *Is this possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
=SUM(IF((ISNUMBER(A1:A10)*(A1:A101),1,0)
insert with Ctrl+Shift+Enter |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
On Mar 25, 3:00*pm, Pete_UK wrote:
If your cells are in column A, then try this: =COUNTIF(A:A,"1") Hope this helps. Pete On Mar 25, 7:43*pm, tonyalt3 wrote: I would like to count how many cells only IF they contain a value greater than 1. *Is this possible?- Hide quoted text - - Show quoted text - Thanks Pete, but I need to make sure it does NOT count any cells w/ zeros in it. This seems to still count them. Any other suggestions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
On Mar 25, 2:58*pm, Gord Dibben <gorddibbATshawDOTca wrote:
=COUNT(A1:A123,"1") Adjust range to suit. Gord Dibben *MS Excel MVP On Tue, 25 Mar 2008 12:43:22 -0700 (PDT), tonyalt3 wrote: I would like to count how many cells only IF they contain a value greater than 1. *Is this possible?- Hide quoted text - - Show quoted text - Gord, This is still counting cells w/zeros in it, any other thoughts? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count/if/and function?
I would like to count how many cells only IF they contain a value
greater than 1. Is this possible?- Hide quoted text - - Show quoted text - If your cells are in column A, then try this: =COUNTIF(A:A,"1") Hope this helps. Thanks Pete, but I need to make sure it does NOT count any cells w/ zeros in it. This seems to still count them. Any other suggestions? Did you try it? It works fine on my system. Note, Pete is suggesting COUNTIF, not COUNT. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count IF Function | Excel Worksheet Functions | |||
COUNT Function | New Users to Excel | |||
Count Function | Excel Discussion (Misc queries) | |||
Count Function | Excel Worksheet Functions | |||
count function | Excel Discussion (Misc queries) |