Simple Subtraction Question - Cell Contains Formula

I have a hard keyed number in a cell (113), in cell to right is a formula =COUNTIF(Status3:Status97, OR(@cell = "Active", @cell = "Invited")), resulting in a count of 93. 

I am trying to subtract the 113 from 93, with result of 10 displayed. I know this is simple but I can't figure it out!



  • based on what I think you are asking, try:

    =$[Column?]$133 - COUNTIF(Status3:Status97, OR(@cell = "Active", @cell = "Invited")), 

    you didn't mention the column name of cell(133)

Help Article Resources