Thread: SUM of alphanumeric cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Why Tea Why Tea is offline
external usenet poster
  
Posts: 13
Default SUM of alphanumeric cells
How to use SUM to sum the following cells A1:A6?

10 hours
1 hour
3 hours

123 hours
5 hours

Note, row 4 (A4) is blank.

/Why Tea
Reply With QuoteReply With Quote