Combining Coutif and Indirect

I have a workbook with multiple worksheets. The first one is a series of small table that use a variety of formulas to summarize the data from a particular year. The other worksheets are set up identically, and each represent a different year: Tab 1 = Dashboard; Tab 2 = 2017_2018; Tab 3 = 2018_2019; etc. I am trying to dynamically fill the dashboard with the appropriate year's data by using the Indirect function. I've been successful using Indirect to pull data from one cell into another using this: =INDIRECT("'"&$A$3&"'!"&"$C$111") where A3 lists the tab name (i.e. 2017_2018). I tried using the same string in a countif formula, and I keep getting the message (You entered too few arguments for this function). Here is the formula I'm trying to enter: =COUNTIF(INDIRECT("'"&$A$3&"'!"&"$C$3:$C$30","JULY"))

I will also need to use this formula with Sumif. Can you tell me what I'm doing wrong?

Thanks!