right now i have this:
=COUNTA(incoming(offset2),outgoing(offset-1))
i tried the offsets, because under the incoming range name placeholder i have the count formula that should display the number counted. so in A2 i have INCOMING, then in A3 i have the formula, then A4:A22 i have data, but more rows will be added. A25 is OUTGOING range name placeholder, but again, that will be pushed down as more incoming rows are added. the OUTGOING count is easy because it just goes to the end of the sheet![]()
Bookmarks