Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count non-empty cells
I have a range of cells with various values (dates, letter N, letter P). I
want to count the number of cells within the range that don't have the letter N. I don't want to add contents, just get the number of cells that contain a value. Can someone tell me how this is done? -- ----------- Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count non-empty cells
SteveT, here is one way,
=COUNTA(A1:A20)-COUNTIF(A1:A20,"n") -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "SteveT" wrote in message ... I have a range of cells with various values (dates, letter N, letter P). I want to count the number of cells within the range that don't have the letter N. I don't want to add contents, just get the number of cells that contain a value. Can someone tell me how this is done? -- ----------- Thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count non-empty cells
How does this question relate to your topic.
i = Application.Countif(Range("A1:Z26"),"<N") j = Application.CountBlank(Range("A1:Z26")) -- Regards, Tom Ogilvy "SteveT" wrote in message ... I have a range of cells with various values (dates, letter N, letter P). I want to count the number of cells within the range that don't have the letter N. I don't want to add contents, just get the number of cells that contain a value. Can someone tell me how this is done? -- ----------- Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the number of cells not empty? | Excel Discussion (Misc queries) | |||
Count Empty Cells in Range After Cells with Data | Excel Programming | |||
count for empty cells | Excel Discussion (Misc queries) | |||
count non empty cells if other cell has certain value | Excel Discussion (Misc queries) | |||
How do I count cells in spreadsheet that are not empty? | Excel Programming |