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

Report
-
 Blocked Profile -
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.

4 replies

Posts
11513
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
July 10, 2020
4
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!