Help

How do i use a dynamic name range to replace static cell names? I have been trying with no such luck.

1. I have created =OFFSET(IssueType!$A$2,0,0,COUNTA(IssueType!$A:$A),1) (NOT sure if its correct) Which I am hoping should start at A2and add all cells below).

2. If I use the name rage how do I actually use it within a formula?

Example:

=COUNTIFS(general_report!"IssueType!,"=Incident", general_report!F$2:F$297,"=P1",general_report!G$2:G$297,"=Resolved")

Also using the dynamic name range would I still need to use the worksheet name like above which is general_report!

Thanks