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

Question

Hi,
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?
thanks.

yg_be · Answer

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?

ac3mark · Answer

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.

kieferschild · Answer

Hi Mark
Cell x has a number value with no formula 
I'll give it a shot when back in the office

kieferschild · Answer

Hi Mark,
This is exactly what I wanted, thanks!

Cell format - COUNTIF then subtract from another cell

4 responses

Similar discussions

Subscribe To Our Newsletter!