Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help: Add cells with certain text + cells that are blank
I know this is easier than I'm making it out to be - It's got to be!
I need to count cells in a column only if they are blank or if they contain a specified text (in this case, it happens to be "N/A"). What formula do I use? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help: Add cells with certain text + cells that are blank
There may be easier ways, but in an adjacent cell, click, Insert then
Function, then Countblank, a dialog box will appear. Select the range of cells and the formula will return your blanks. Subtract the number of blank cells from the total and it will give you the number of "N/A" cells. "Nicole L." wrote: I know this is easier than I'm making it out to be - It's got to be! I need to count cells in a column only if they are blank or if they contain a specified text (in this case, it happens to be "N/A"). What formula do I use? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help: Add cells with certain text + cells that are bla
Actually, I need to count cells that are blank and cells that have "textA" in
them. "Lost in Microbiology" wrote: There may be easier ways, but in an adjacent cell, click, Insert then Function, then Countblank, a dialog box will appear. Select the range of cells and the formula will return your blanks. Subtract the number of blank cells from the total and it will give you the number of "N/A" cells. "Nicole L." wrote: I know this is easier than I'm making it out to be - It's got to be! I need to count cells in a column only if they are blank or if they contain a specified text (in this case, it happens to be "N/A"). What formula do I use? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help: Add cells with certain text + cells that are blank
=COUNTIF(A1:A12,"textA")+COUNTBLANK(A1:A12)
Adjust your range to suit "Nicole L." wrote: I know this is easier than I'm making it out to be - It's got to be! I need to count cells in a column only if they are blank or if they contain a specified text (in this case, it happens to be "N/A"). What formula do I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop text displaying in blank adjacent cells? | Excel Discussion (Misc queries) | |||
Ignoring blank cells while locating common text value | Excel Discussion (Misc queries) | |||
Need blank formula cells rather than 0's | Excel Worksheet Functions | |||
How do i keep cells blank until the formula is used? | Excel Discussion (Misc queries) | |||
blank cells that include text | Excel Worksheet Functions |