Results 1 to 3 of 3

Counting numbers even if there text in the column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-13-2010
    Location
    Warren, Michigan
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    307

    Counting numbers even if there text in the column

    I have a document which has the hours for a week (6 dayS) - within those that week PC (personal time) and VT (vacation time) is marked.

    Example:

    F9: 11
    G9: 7.75
    H9: 6.75
    I9: 7.75
    J9:
    K9: PC

    The total should be 33.25, I'm using a =SUM(F9+G9+H9+I9+J9+K9) and I'm getting #VALUE!.

    I know this should be a simple coding - I guess I'm just brain dead today. Any suggestions for my hang-up?
    Last edited by khank; 04-27-2011 at 08:34 PM.

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1