How can I exclude a cell containing text from a "sum" calculation in another cell?
A andrewcu Jul 2, 2008 #1 How can I exclude a cell containing text from a "sum" calculation in another cell?
A andrewcu Jul 2, 2008 #3 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
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
