IF function on different spreadsheet

Occasional Visitor



I am trying to create a summary page on excel. I want this summary page only to show 'open' cases that are on the other tabs. 


I can't figure out the formular for this. I want it to say that if a case reads open, to appear on summary page one. 


Any ideas?

1 Reply


Maybe advanced filter can help you. In the attached file you can click the button in cell D4 to display all open cases. Advanced filter can be applied for different worksheets as well. If you work with Office365 or 2021 you can apply FILTER function instead of advanced filter.