I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row.  I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not


Our team is looking for a way to count the number of projects of three distinct types.  I have them located within three different folders.  I do not want to have to use cell linking.  A user should be able to create a new project without having to open a summary sheet and create a new cell link.