Formula to subtract a cell with a Green tick image and show a total remaining
Every time I put a Green tick in the KEY column, I want it to subtract the TERMINAL cell within that row and to update the Remaining Terminals to be built.
For example: I have put a GREEN tick in KEY5
So I want BRANCH2 to display the remaining terminals to be built, which should be 14
Hopefully I made sense :-)
Help Article Resources
Check out the Formula Handbook template!