| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
text data - excluding rows
Can I exclude rows when counting data in a column? Eg. can I count rows 1-20
and then 50-100 in the one function, or do I have to do it separately? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
text data - excluding rows
Is the data in the column only text or is both text and numbers?
If it's text only: =COUNTA(A1:A20,A50:A100) If the data is both text and numbers: =COUNTA(A1:A20,A50:A100)-COUNT(A1:A20,A50:A100) -- Biff Microsoft Excel MVP "excelbeginner" wrote in message ... Can I exclude rows when counting data in a column? Eg. can I count rows 1-20 and then 50-100 in the one function, or do I have to do it separately? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excluding Hidden Rows from calculations | Excel Worksheet Functions | |||
| Sum of a column excluding hidden rows | Excel Worksheet Functions | |||
| Counting non-blank cells in a column, excluding hidden rows | Excel Worksheet Functions | |||
| How can I print a worksheet excluding blank rows? | Excel Worksheet Functions | |||
| paste excel sheet excluding hidden rows | Excel Discussion (Misc queries) | |||
Linear Mode
