Forum Discussion
Date Range Finder, Sheet 2, Formula Issue
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.
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.
2 Replies
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.
