Skip false rows in If function

Hi Everyone,

I have an issue that I can't seem to work around that I was hoping you all could help me out with if possible. Here's the situation...

I have a spreadsheet with month tabs and a summary tab. What my user wants is to have the summary sheet pull data from the month sheets into a concise, easy to read format. They want it sorted by "month" and a column called "funnel". They want the formula to pull data from the "title" column and fit it into the appropriate "funnel" on the summary sheet. I have attached a copy of the spreadsheet as an example. I also did a manual copy and paste on a few to show what I'm talking about. They would like this to be automated if possible. I've been stumped as to how to make this happen. I want the formula to be able to skip rows that don't match the appropriate "funnel" for the summary sheet. It's too complicated for my current excel skill level.

Any ideas?

Thanks a lot in advance.

Editorial%20Calendar%20June-December%202013.xlsx

Hi Robert,

Thanks a lot for the response. The formula does work well so I'm excited to see that. The only thing is when I try to extend the formula to include the blank cells below row 29 (so the user has space to enter new data to her month tabs and it populate on the summary tab) it breaks the formula. Do the {} brackets have anything to do with it?

calendar.xlsx

Any thoughts?

Thanks again.

Thanks a lot! This works great now and I learned something new in the process. Will mark this as solved and click the star icon for a job well done.