View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
spidut spidut is offline
external usenet poster
 
Posts: 1
Default SUM NUMBERS WITH APPENDING TEXT

I have a problem on hoe to deal with this data:
in a column data are as follows:
5N
4N
3
4
3N and so on
Now i'd like to sum up all numbers with appending text, and counting cells
having "N",and count cells without "N". I hope somebody can urgently help
me..thanks