Dynamic row count

[clientserviceanonymous]

Hi all,

I am setting up a spreadsheet that pulls all of my credit card transactions. Once they are pulled, I manually categorize them.

I have an issue with a formula that is supposed to count the number of uncategorized transactions (so I know to update them). Here is what I wrote:

=COUNT(Transactions!E2:OFFSET(Transactions!E602,-1,0))-(COUNTIF(Transactions!D:D,"<>")-1)

My goal is to interpret this as, "Number of total transactions - transactions with blank categories = amount of transactions needing categories"

I thought the offset function would manually update as data is added to the spreadsheet. For example, the newest data is always added to the second row and below (first row is a label). So if I added 10 transactions, I thought offset would update to E612. However, the offset function stays at E602 no matter what.

Any help would be appreciated! Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about
=COUNTIF(Transactions!E:E,"<>")-COUNTIF(Transactions!D:D,"<>")

 

[clientserviceanonymous]

Hi & welcome to MrExcel.
How about
=COUNTIF(Transactions!E:E,"<>")-COUNTIF(Transactions!D:D,"<>")

Awesome, thank you!

 

[Fluff]

You're welcome & thanks for the feedback