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
17702
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
November 29, 2021
5
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?
1
Thank you

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

CCM 2821 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.
1
Thank you

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

CCM 2821 users have said thank you to us this month


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!