colinheslop1984
Board Regular
- Joined
- Oct 14, 2016
- Messages
- 129
- Office Version
- 2016
LEEDS | |
DRESS | =SUMIF(INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!C$12:C$25"),$C9,INDIRECT("'[JAMIE SHEET LEEDS.xlsx]"&$C$5&"'!J$12:J$25")) |
DENIM | |
SHIRT |
<tbody>
</tbody>
<tbody></tbody>
Where JAMIE SHEET LEEDS is the data source which has multiple worksheets.
The INDIRECT function is being used because C5 has a filter to select week number (which represents the worksheets of the data source)
C12:C25 is a criteria (dress, denim, etc as above)
J12:J25 the value I need to sum.
I need this info to display on my master document without it needing to be open.
Please help.