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

Posts
2505
Registration date
Sunday October 5, 2008
Status
Moderator
Last seen
September 16, 2019
- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- Dec 20, 2016 at 11:25 AM
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.
See more 

4 replies

Posts
9064
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 8, 2019
2
0
Thank you
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?
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571
0
Thank you
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.
Posts
2505
Registration date
Sunday October 5, 2008
Status
Moderator
Last seen
September 16, 2019
415
0
Thank you
Hi Mark

Cell x has a number value with no formula

I'll give it a shot when back in the office
Posts
2505
Registration date
Sunday October 5, 2008
Status
Moderator
Last seen
September 16, 2019
415
0
Thank you
Hi Mark,

This is exactly what I wanted, thanks!
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1571 -
Yes sir! My pleasure!