Hello,
I need to sum some lines of a database, using filters, and conditions such as ">0", "<0", etc.
To use a filter and sum just the visible lines, i use subtotal(9;L:L).
Now the problem is to select the positive values, or the negative ones, only in shown lines.
After all, it's like making a combination os subtotal() and sum.if()
Any suggestions?
Bye
Bookmarks