P
PoE~
This might be hard to explain, so please bear with me.
Okay, so here's the situation: I set up a spreadsheet to keep track of
my sports betting. I have a column for the potential dividend, and a
column for 'Match Status', being "Win", "Loss" or "Pending". If W is
typed in the "Match Status" column, the cell next to it displays the
the amount earned from that bet.
I also have a column that adds up the amount i can potentially earn
from the matches that are pending, but at the moment i have to
manually select the cells that have bets pending. So what I want to do
is, have a cell that adds up all the bets that have "Pending" next to
their corresponding amounts. I hope you understand, thanks in advance.
Okay, so here's the situation: I set up a spreadsheet to keep track of
my sports betting. I have a column for the potential dividend, and a
column for 'Match Status', being "Win", "Loss" or "Pending". If W is
typed in the "Match Status" column, the cell next to it displays the
the amount earned from that bet.
I also have a column that adds up the amount i can potentially earn
from the matches that are pending, but at the moment i have to
manually select the cells that have bets pending. So what I want to do
is, have a cell that adds up all the bets that have "Pending" next to
their corresponding amounts. I hope you understand, thanks in advance.
