Date Range Finder, Sheet 2, Formula Issue

[RoyJr]

Hello,

Using the below formulas on sheet1 to find a date range total. It is working perfectly:

(Date 1) =SUMPRODUCT(($H$11:$H$25000>=E1)*($H$11:$H$25000<=E2))

(Date 2) =SUMPRODUCT(($L$11:$L$25000>=E1)*($L$11:$L$25000<=E2))

However, I want to add the date range finder to sheet2 (my dashboard) and extract the information from sheet1. Having trouble figuring out the correct formula.  

Please advise.

Thank you.

[#2 · Accepted solution]

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.

[#3]

@Ingeborg Hawighorst 

That is exactly what was needed. Functions perfectly.

Thank you so much.