+ Reply to Thread
Results 1 to 2 of 2

Cannot change a formula

  1. #1
    Richard F
    Guest

    Cannot change a formula


    I am using a worksheet that counts the number of days
    employees have worked. The worksheet was written by someone else who
    have left. I need to change the number of some rows in this formula.


    =COUNTIF(D$14:D$160,$V32)+COUNTIF(D$175:D$225,$V31)+M250+M238

    M250 and M238 are the results of another countif formula. When I try
    and change the number of the rows to M251 and M 239 the formula no
    longer returns a value and I see the formula in the cell on the
    worksheet. Also the different values of the rows and columns become
    colored. How can I change the formula so it returns the value its
    supposed to?

    Richard

  2. #2
    Michael
    Guest

    RE: Cannot change a formula

    Hi Richard
    If you double click on the part of the formula you want to change in the
    formula Bar at the top of the page, and then mouse click on the cell location
    you want to replace it with, there should be no problem with the running of
    the formula.
    Also, make sure the formula has the = sign at the beginning of it, otherwise
    all you will see is the formula as text.

    HTH
    Michael




    "Richard F" wrote:

    >
    > I am using a worksheet that counts the number of days
    > employees have worked. The worksheet was written by someone else who
    > have left. I need to change the number of some rows in this formula.
    >
    >
    > =COUNTIF(D$14:D$160,$V32)+COUNTIF(D$175:D$225,$V31)+M250+M238
    >
    > M250 and M238 are the results of another countif formula. When I try
    > and change the number of the rows to M251 and M 239 the formula no
    > longer returns a value and I see the formula in the cell on the
    > worksheet. Also the different values of the rows and columns become
    > colored. How can I change the formula so it returns the value its
    > supposed to?
    >
    > Richard
    >


+ Reply to Thread

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