Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF
I need to count how many cells in a column contain anything, hence not
counting blank ones. =COUNTIF(range,criteria) what would the criteria be? |
#2
|
|||
|
|||
=COUNTA(a1:a10)
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "luvthavodka" wrote in message ... I need to count how many cells in a column contain anything, hence not counting blank ones. =COUNTIF(range,criteria) what would the criteria be? |
#3
|
|||
|
|||
=COUNTA(Range)
would skip empty cells but will include a cell with ="". luvthavodka wrote: I need to count how many cells in a column contain anything, hence not counting blank ones. =COUNTIF(range,criteria) what would the criteria be? -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
#4
|
|||
|
|||
Just to follow the subject line:
=COUNTIF(A:A,"<") -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "luvthavodka" wrote in message ... I need to count how many cells in a column contain anything, hence not counting blank ones. =COUNTIF(range,criteria) what would the criteria be? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |