Results 1 to 3 of 3

Counting text in range subtracting from par

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2007
    Location
    Orlando, Florida
    Posts
    48

    Counting text in range subtracting from par

    With the help of daddylonglegs on this forum, I have created a schedule that works very well for what I am trying to do. The issue I am having now, is taking a range of cells, checking to see if it has text, adding the number of cells in the range together, and subtracting it from a par. I have tried using the sumif function, which, by my programming, gave me an error everytime, and I have tried this code as well.
    =SUM(COUNTIF(D6:D13,ISTEXT(D6:D13)),-D67)
    It's subtracting from the par, but it's not adding the cells containing the text together first. Will someone point me in the right direction? Thank you !!
    Attached Files Attached Files

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