adding cells with text values

February 8, 2011 at 08:28:36
Specs: Windows 7
I need to add many individual cells together that are formatted as iferror, return "-". I do not want to change the "-" to 0 because i don't want to see a thousand 0's, but that is the only way i can get the value in the cell i want

See More: adding cells with text values

Report •

February 8, 2011 at 10:08:01
Perhaps it would help if you posted the formula you are using so that we can get a better idea of your issue.

If you are trying to count text values, perhaps COUNTIF or COUNTA will get you what you are looking for.

Bottom line is that I don't think we have enough information to give you a concrete answer.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question