| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count cells with text in them?
I just want to count the number of cells in a row that contain text. Some
cells will be empty and others will contain a text such as HNOV03, which identifies a crate. A row of cells could have only one crate or it could list several. I could continue to count them manually and insert the sum, but I keep forgetting. If there were a formula in the form it would always have the correct sum. TIA, Dave |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count cells with text in them?
Try COUNTA function:
e.g =COUNTA(3:3) will count cells not empty in row 3 "Dave McCuen" wrote: I just want to count the number of cells in a row that contain text. Some cells will be empty and others will contain a text such as HNOV03, which identifies a crate. A row of cells could have only one crate or it could list several. I could continue to count them manually and insert the sum, but I keep forgetting. If there were a formula in the form it would always have the correct sum. TIA, Dave |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count cells with text in them?
Toppers,
This almost works, but I found I also need the letter reference for the cells to be counted. Thanks this is a big help. Why didn't they put this in the Help index? Microsoft always makes things difficult. Dave "Toppers" wrote: Try COUNTA function: e.g =COUNTA(3:3) will count cells not empty in row 3 "Dave McCuen" wrote: I just want to count the number of cells in a row that contain text. Some cells will be empty and others will contain a text such as HNOV03, which identifies a crate. A row of cells could have only one crate or it could list several. I could continue to count them manually and insert the sum, but I keep forgetting. If there were a formula in the form it would always have the correct sum. TIA, Dave |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count cells with text in them?
=Counta(A1:Z1), where A1:Z1 is the row range you're looking at. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=524988 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count cells with text in them?
=Counta(A1:Z1), where A1:Z1 is the row range you're looking at. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=524988 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| Count Text Values in Column | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
Hybrid Mode
