is it possible to COUNT between two named ranges?

good day all...i have been toying with a formula for a bit and have not gotten anywhere. i have a named range, a placeholder really, in cell A2. now, in cell A5, there is another named range. i need a formula that will COUNTA between those two ranges, not including the ranges themselves. the kicker here is, that data is inserted after the last row via vba so the 2nd named range in A5...will change, to A6 or to A7, etc. however the named range doesn't change. that is why i need this formula.

i have tried =counta(test1:test2) but of course that would have been too easy

thank you for any help!

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

yeah i probably screwed up the offset syntax. incoming and outgoing are my defined ranges. they are just a single cell. incoming is in cell A2 and the data starts in cell A4. rows will be added before the outgoing cell. my problem is that when i run a COUNTA, it does not continue as i add rows. say, if i have data in A4:A23 and COUNTA those rows, if i add a row somewhere there with data in it, it STILL only counta from A4:A23. when i add a row, the cell with "outgoing" value moves down, the named range moves with it. so if i can run a COUNTA between two named ranges it should automatically update. this is confusing, i know. i tried to make up a test sheet and attach it. i'm not sure if its even possible. i might just have to use some VBA code to add it in a different way.

yeah i probably screwed up the offset syntax. incoming and outgoing are my defined ranges. they are just a single cell. incoming is in cell A2 and the data starts in cell A4. rows will be added before the outgoing cell. my problem is that when i run a COUNTA, it does not continue as i add rows. say, if i have data in A4:A23 and COUNTA those rows, if i add a row somewhere there with data in it, it STILL only counta from A4:A23. when i add a row, the cell with "outgoing" value moves down, the named range moves with it. so if i can run a COUNTA between two named ranges it should automatically update. this is confusing, i know. i tried to make up a test sheet and attach it. i'm not sure if its even possible. i might just have to use some VBA code to add it in a different way.

no worries! i got it...used some good ole code for some automation and it works well!

Please Login or Register  to view this content.