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