Perhaps post a sample sheet, your date's format might be the problem

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Good morning. Here is my sample sheet. the formula is located on the TRIAL BALANCE tab cell N7. The date range of dollar activity is located on the SHAREHOLDER TRANSACTIONS tab.

Any help is greatly appreciated!!!

Attached Files

Book2v2.xlsx (52.9 KB, 9 views)