Find Empty Cell Check Next Column For a Value

Hello Everybody,

Does anybody know how to create a macro that will start in D20 and check to see if there is no value. If D20 has no value in the cell it will then check E20 to see if it has a value. If E20 has a value it will then go to E19 and increase the count. I'm trying to find the total amount of files that have value in them by checking two columns and then keeping a running counter in Cell E19. This macro would also need to run for 5000 rows because I will have a lot of information on my actual documents. I included a sample on the information I would be working with. Thanks again for your help to whoever can solve this for me. Sample.xlsx

That works right now on the sample. I'll see if it works on my master sheet. Thanks for the help.

Ok, this next portion is similar to the previous task and it can probably just edit the last macro. But say i want to start on J20 and check the next 5000 rows for any values. Every cell that has a value it will keep a running count in Cell J19.