ExcelBanter - Excel text formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel text formula (https://www.excelbanter.com/excel-discussion-misc-queries/193425-excel-text-formula.html)

andrewcu

Excel text formula

How can I exclude a cell containing text from a "sum" calculation in another
cell?

Bob Phillips[_3_]

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?

andrewcu

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?

All times are GMT +1. The time now is 06:36 PM.