Cell format - COUNTIF then subtract from another cell

Blocked Profile - Dec 16, 2016 at 07:09 AM
 Blocked Profile - Dec 20, 2016 at 11:25 AM

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?


4 responses

yg_be Posts 22720 Registration date Sunday June 8, 2008 Status Contributor Last seen April 23, 2024 5
Dec 16, 2016 at 02:40 PM
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?