| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need this formula to exclude cell value 'x' and 'xx' when counting
Hi. I have a function that will count 1 every time there is text in a cell.
Is there a way to get the following function to count all cells having text and exclude cells that contain cell values: 'xx' or x? =SUM(IF(ISTEXT(C17:K17),1,0)) Please help me. Thanks. Misty -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need this formula to exclude cell value 'x' and 'xx' when counting
=SUM(IF(ISTEXT(C17:K17),1,0))-COUNTIF(C17:K17,"x")-COUNTIF(C17:K17,"xx")
as an array formula -- Gary''s Student - gsnu2007j "Mitchell_Collen via OfficeKB.com" wrote: Hi. I have a function that will count 1 every time there is text in a cell. Is there a way to get the following function to count all cells having text and exclude cells that contain cell values: 'xx' or x? =SUM(IF(ISTEXT(C17:K17),1,0)) Please help me. Thanks. Misty -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need this formula to exclude cell value 'x' and 'xx' when counting
Thanks!
Misty -- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200807/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude weekends when counting days only on day 29 or 30 | Excel Worksheet Functions | |||
| charts exclude cell with formula | Charts and Charting in Excel | |||
| Excel 2003 - SUM Formula - exclude cell | Excel Worksheet Functions | |||
| formula for counting charachters in a cell ? | Excel Discussion (Misc queries) | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
Linear Mode
