B
Brett Baisley
Hello,
Right now I have an excel spreadsheet with 2 columns. One is "Price" and one
is "Paid". The Price has a listing of different prices and Paid has a Y/N
value if it has been paid or not.
I am trying to write a formula that will total up the amount I still owe.
So, I am trying to write a formula that will SUM all of the values in the
Price column only if there is an "N" in the corresponding Paid column.
I'm having troubles doing this, can someone please help me?
I got this far, but it is not working:
=SUMIF(B3:B9,D3
9="N")
Right now I have an excel spreadsheet with 2 columns. One is "Price" and one
is "Paid". The Price has a listing of different prices and Paid has a Y/N
value if it has been paid or not.
I am trying to write a formula that will total up the amount I still owe.
So, I am trying to write a formula that will SUM all of the values in the
Price column only if there is an "N" in the corresponding Paid column.
I'm having troubles doing this, can someone please help me?
I got this far, but it is not working:
=SUMIF(B3:B9,D3
9="N")