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

Posts
2441
Registration date
Sunday October 5, 2008
Status
Moderator
Last seen
November 14, 2018
- Dec 16, 2016 at 07:09 AM - Latest reply:
Posts
10849
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 15, 2018
- 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 
Related:

5 replies

Posts
6871
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
November 16, 2018
- Dec 16, 2016 at 02:40 PM
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
10849
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 15, 2018
- Dec 16, 2016 at 04:56 PM
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
2441
Registration date
Sunday October 5, 2008
Status
Moderator
Last seen
November 14, 2018
- Dec 17, 2016 at 04:08 PM
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
2441
Registration date
Sunday October 5, 2008
Status
Moderator
Last seen
November 14, 2018
- Dec 20, 2016 at 07:32 AM
0
Thank you
Hi Mark,

This is exactly what I wanted, thanks!
Posts
10849
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 15, 2018
- Dec 20, 2016 at 11:25 AM
Yes sir! My pleasure!