Formula to subtract a cell with a Green tick image and show a total remaining

Dean Sadler

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 :-)

Screenshot 2021-03-09 17.30.05.png

Heather Duff

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

Heather Duff

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

Dean Sadler

Hi Heather.

Superstar. Thanks 😋