Cell format - COUNTIF then subtract from another cell [Solved/Closed]

 Blocked Profile -

I have a spreadsheet with holidays on.

I'm using =COUNTIF(D16:D380,"H")

I want to then subtract this number from another cell - What do I need to add on to this formula?


4 replies

Registration date
Sunday June 8, 2008
Last seen
October 25, 2020
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.

Hi Mark

Cell x has a number value with no formula

I'll give it a shot when back in the office

Hi Mark,

This is exactly what I wanted, thanks!
Blocked Profile
Yes sir! My pleasure!