Hi Gerry, Don't know which formulas you use now, SUMIF or SUMIFS or SUMPRODUCT could give you any desirable combination. For example, let assume you have in A1:A10 dates of the bills, in column B amounts and in column C the status ("Paid" or empty). Not paid sum could be calcula...
=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...
=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)...
=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)...