close
I have a column that contains text and data, never in the same cells, but I
want to separate the numbers from the text in order to do a total at the
bottom. Is there a formula for this?
Amber
Assume text is text and data is numeric, just SUM the column. Excel will ignore
the text.
=SUM(A:A) entered in B1 should give you the total of any numbers in column A..Gord Dibben MS Excel MVP
On Tue, 4 Apr 2006 14:36:02 -0700, Amber gt;
wrote:
gt;I have a column that contains text and data, never in the same cells, but I
gt;want to separate the numbers from the text in order to do a total at the
gt;bottom. Is there a formula for this?
全站熱搜
留言列表
