# Sum column with text

1. ## Sum column with text

I have a column where some cells have numbers and some have text, specifically N/A. I just want to sum only the numbers on that column. I think this should be pretty easy. But I have tried different formulas and none of them seems to work. Any help will be highly appreciated.  Register To Reply

2. ## Re: Sum column with text

If your numbers are in A1 to A15 then enter this formula using Ctrl Shift Enter

=SUM(IF(ISNUMBER(A1:A15),A1:A15,0))  Register To Reply

3. ## Re: Sum column with text

=aggregate(9,6,a1:a15)  Register To Reply

4. ## Re: Sum column with text

That worked! Thank you!  Register To Reply

5. ## Re: Sum column with text

Hi

In my Excel2010, using =SUM(A1:A15) ignores all text values in the range and just gives the numeric total.
It's only if there are error values within that range (like #N/A) that gives an error for the SUM (i.e text value of N/A is ignored, but #N/A is not)

zeddy  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 