Can you give an example of what you actually mean by "subtract this number from another cell"? Is there a formula already in that other cell?
So if the cell formula now is, for example, summing two other cells, like:
cell A1 contains the formula =SUM(B1:B10);
and you wish to include that sum into the new total, the cell formula of cell A1 would now be: =Sum(B1:B10)-COUNTIF(D16:D380,"H")
I hope this is what you are looking for. I have tested it and it works.
Cell x has a number value with no formula
I'll give it a shot when back in the office
This is exactly what I wanted, thanks!