Date Range Finder, Sheet 2, Formula Issue

Hi RoyJr 

What information do you want to extract from Sheet1? Is the data range on Sheet1? Is E1 on Sheet1?

You can put the sheet name in front of the cell reference like this:

Sheet1!A1

If the sheet name has a space in it, you need to wrap it in single quotes like this:

'My Data'!A1

Without knowing your data, it's hard to suggest the formula you need but maybe something like

=SUMPRODUCT(('Data Sheet'!$H$11:$H$25000>=Dashboard!E1)*('Data Sheet'!$H$11:$H$25000<=Dashboard!E2))

Just apply the syntax 'Sheet Name'!CellRange.