Hello, I am new to the forum so any help is appreciated in advance. I am trying to create a formula that will reference another sheet to add all items from column G based on a date range in column A. Then I need it to subtract from a cell on the original page. Here is the actual cells/needs:

Formula will be housed in E9 on sheet 1
It should reference sheet 2 and look for a specific date range within column A (7/30-8/5 for example)
Once it has grouped by this data, I want it to add the values from column D (still sheet 2)
Then I want it to subtract that total from C9 on sheet 1

Not sure if I am missing information that anyone may need to help, but this is the gist of what I am trying to accomplish. The biggest problem I am having is getting the sheet to sheet referencing to not interfere with the formula, I am a relative novice with formula writing. Again, thanks in advance for any help anyone may be able to provide.

JM