Hello, I am creating my own Bill Tracker with a cell that has the $ amount that i owe and a cell that when i pay that amount i check it to show paid.At the bottom of the $ cells i have a total amoun... Hi Gerry, Don't know which formulas you use now, SUMIF or SUMIFS or...
Hello, I am creating my own Bill Tracker with a cell that has the $ amount that i owe and a cell that when i pay that amount i check it to show paid.At the bottom of the $ cells i have a total amoun... Hi Gerry, Don't know which formulas you use now, SUMIF or SUMIFS or...
Thank You for your time. Gerry, when in D32 the sum of non-paid bill will be =SUMIF(E3:E30,"<>x",D3:D30) If you mean the what you owe is the sum of all not paid bills and you'd like to have the differrence between above and paid bills when...
Hello, I am creating my own Bill Tracker with a cell that has the $ amount that i owe and a cell that when i pay that amount i check it to show paid.At the bottom of the $ cells i have a total amoun... Hi Gerry, Don't know which formulas you use now, SUMIF or SUMIFS or...
=SUMIF(E3:E30,"<>x",D3:D30) If you mean the what you owe is the sum of all not paid bills and you'd like to have the differrence between above and paid bills when =SUMIF(E3:E30,"<>x",D3:D30)-SUMIF(E3:E30,"x",D3:D30)...
Hello, I am creating my own Bill Tracker with a cell that has the $ amount that i owe and a cell that when i pay that amount i check it to show paid.At the bottom of the $ cells i have a total amoun... Hi Gerry, Don't know which formulas you use now, SUMIF or SUMIFS or...
Hello, I am creating my own Bill Tracker with a cell that has the $ amount that i owe and a cell that when i pay that amount i check it to show paid.At the bottom of the $ cells i have a total amoun...
Diffrence in values Hello, I am creating my own Bill Tracker with a cell that has the $ amount that i owe and a cell that when i pay that amount i check it to show paid.At the bottom of the $ cells i have a total amoun......