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
May 10, 2021
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?
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

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!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!