| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel text formula
How can I exclude a cell containing text from a "sum" calculation in another
cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel text formula
SUM automatically ignores text.
-- __________________________________ HTH Bob "andrewcu" wrote in message ... How can I exclude a cell containing text from a "sum" calculation in another cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel text formula
Many thanks. What I had done was not the FUNCTION "SUM", but had just done "= cel1 + cell2". When I used the fx button the problem has gone. Saved me a couple of hours - thanks again. Andrew "Bob Phillips" wrote: SUM automatically ignores text. -- __________________________________ HTH Bob "andrewcu" wrote in message ... How can I exclude a cell containing text from a "sum" calculation in another cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does Excel change formula to text ? | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
| ExcelExcel 2002 display formula in another cell as text | Excel Worksheet Functions | |||
| How do I set up a formula to insert text in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
