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

kieferschild 2428 Posts Sunday October 5, 2008Registration dateModeratorStatus September 21, 2018 Last seen - Dec 16, 2016 at 07:09 AM - Latest reply: ac3mark 10525 Posts Monday June 3, 2013Registration dateModeratorStatus September 21, 2018 Last seen
- 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 

5 replies

yg_be 6477 Posts Sunday June 8, 2008Registration dateContributorStatus September 21, 2018 Last seen - 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?
ac3mark 10525 Posts Monday June 3, 2013Registration dateModeratorStatus September 21, 2018 Last seen - 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.
kieferschild 2428 Posts Sunday October 5, 2008Registration dateModeratorStatus September 21, 2018 Last seen - 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
kieferschild 2428 Posts Sunday October 5, 2008Registration dateModeratorStatus September 21, 2018 Last seen - Dec 20, 2016 at 07:32 AM
0
Thank you
Hi Mark,

This is exactly what I wanted, thanks!
ac3mark 10525 Posts Monday June 3, 2013Registration dateModeratorStatus September 21, 2018 Last seen - Dec 20, 2016 at 11:25 AM
Yes sir! My pleasure!