formula resolve error

  1. S

    Help!!!! This formula is driving me crazy!!

    Hi! I am trying to use the SUMIF Function and this formula is not working. I have most of it right. I want to SUMIF and I have the range right and the criteria right, but then for the sum range I want to be able to subtract a group of numbers. I cant figure out how to subtract them. It adds them...
  2. S

    Formula/Reference won't resolve into value

    Occasionally I trip into a mode where a formula or simple reference doesn't resolve into the value. This affects ALL newly entered cells in that worksheet, but won't necessarily affect functions in another worksheet in the same workbook. Example: A1 contains a value, say 99...

Some videos you may like

This Week's Hot Topics