Simple Subtraction Question - Cell Contains Formula

02/16/18 Edited 12/09/19

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!

Tags:

Comments

  • 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)

Sign In or Register to comment.