Trying to add numeric values in range

Hi Matt,

After doing your 2 step formula, the =SUMIF doesn't work. I noticed that in the 2nd part, the numbers are on the left side of the cell, maybe the =SUMIF formula thinks that they are text.

Also I just realized that some of the numbers may be a decimal but the highest number would be an eight.

Mike

Yes, you are right. It will show the numbers as text. Just put a =value() statement around it

=VALUE(right(A1,len(A1)-1))

Matt

Thanks Matt,

got it working.

Mike