Report

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

Ask a question kieferschild 2295Posts Sunday October 5, 2008Registration date ModeratorStatus March 16, 2017 Last seen - Last answered on Dec 20, 2016 at 11:25 AM by ac3mark
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 
Helpful
+0
plus moins
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?
Leave a comment
Helpful
+0
plus moins
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.
Leave a comment
Helpful
+0
plus moins
Hi Mark

Cell x has a number value with no formula

I'll give it a shot when back in the office
Leave a comment
Helpful
+0
plus moins
Hi Mark,

This is exactly what I wanted, thanks!
ac3mark 6639Posts Monday June 3, 2013Registration date ModeratorStatus March 13, 2017 Last seen - Dec 20, 2016 at 11:25 AM
Yes sir! My pleasure!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!