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 !!
Bookmarks