Sumif Index Address and Date PLUS pulling an adjustable date range

There's not much point in attaching images of Excel files - they can't be edited to try out different formula approaches, and in this case they are too small to be read anyway.

It would be better if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon to attach files, as it doesn't work on this forum.

Pete

Thanks Pete (And all others willing to give this a shot) -

I have uploaded an example sheet of what I am working on. I want to be able to take the addresses in Blitz Event tab column A,
use the dates in cells B3 and B4 to set a range <> and return data from the Sales Data tab to the Blitz Event tab in column D.
I can get 2 different formulas to get half of my problem but I can't figure out how to put it all together to do in one cell.

Thanks for any help to resolve.
Jennie

Thanks for that, Jennie. I'm just taking a short break for now, but I'll pick this up later on this evening.

Pete

Wow! Thank you Ford. This one plugged and played, perfect! Have a great day.