In an empty Col, say U, enter 1 for each unpaid entry.
Enter your Sum formula as follows, using Ctrl+Shift+Enter, instead of
just Enter, to make it an array formula.
=SUM((T1:T8)*((U1:U8)=1))
Enter the range that fits your needs.
Upon payment delete the entry in the U Col
Ilan