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...
pageTitledescriptionredirect
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 calculated as =SU...
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)","body@stringLength":"317","rawBody":" Gerry, when in D32 the sum of...