overdue bills overdue bills (continued)
occurs to me to make an addition in the form above. Suppose we want to know the outstanding debt at today. In that case we should add only the amounts of past bills on time.
well in this case is the use of SUMAR.SI function, only conditional function "sum if" it meets certain criteria, in this case the condition "win."
The final formula is: = SUMAR.SI (D3: D12, "EXPIRED" C3: C12)
0 comments:
Post a Comment