Need help with countif and indirect.

[Gunship]

Hey all, I'm trying to build a sheet for my company that pulls information by month and then matches the agent name to countif and track total leads. I've setup seperate sheets for each month that log how many sales leads are generated and which agent submitted the lead.

My goal is to create a drop down menu where we can select each month, if the agent name matches it will count the total entries for the month into a column titled Leads.

--------------------------

Main Sheet is called Monthy Stats, Column A has the drop menu to select the month, starting with September. Column B titled Agent Name, and is currently using an importrange from another sheet titled Team Roster. Column C is where I want to populate the total leads if the agent name matches from another sheet titled Sept Leads.

On the September Leads sheet the agents names are populated in Column E.

I hope this is descriptive enough.

 

[Gunship]

Update: I think I've figured it out =COUNTIF(INDIRECT("'"&$A$2&"'!E:E"),"*"&B3&"*") Seems to be populating correctly! Yay!

 

[63falcondude]

Hello and welcome to the forum. I'm glad that you figured out your question and thank you for sharing the solution.

Note that it is important to mention that you are using Google Sheets.

Although you may think that Excel and Google Sheets are the same, they are very different.