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 :-)
Best Answer
-
Hi Dean,
You can use SUMIF to add up all of the values in TERMINALS that have a green tick next to them, then subtract them from the rollout row.
=Terminals3 - SUMIF(KEY:KEY, "Yes", TERMINALS:TERMINALS)
I used "Yes" because that was the only green tick I could find in my settings. If your green tick uses a different word, you'll want to replace my "Yes" with that other word.
Hope this helps!
Best,
Heather
Answers
-
Hi Dean,
You can use SUMIF to add up all of the values in TERMINALS that have a green tick next to them, then subtract them from the rollout row.
=Terminals3 - SUMIF(KEY:KEY, "Yes", TERMINALS:TERMINALS)
I used "Yes" because that was the only green tick I could find in my settings. If your green tick uses a different word, you'll want to replace my "Yes" with that other word.
Hope this helps!
Best,
Heather
-
Hi Heather.
Superstar. Thanks 😋
Help Article Resources
Categories
Check out the Formula Handbook template!