array formula if

Hi... I have read that in old Excel versions (97, 2000) when working with string variables in vba there is a character limit of 255, but also read that Excel 2010 should not have that limitation... I am trying to pass a function in a string variable to an Evaluate method, and I am getting error...

Hello, This is my first post on Mr. Excel and thanks beforehand for any help you can give! My problem is as follows: I am working on a workbook to keep track of individual projects in a company. Each project has its own worksheet. In each worksheet I have a chart estimating labor in distinct...

I've found multiple threads answering the question about using multiple logical tests with an if function with Excel 2010, and the consensus approach is: =IF(AND(Test1,Test2),ValueTrue,ValueFalse) However, when I try to use this in an array formula I end up with a #VALUE! error. I am trying...

In the attached file in the 'Overdue List' tab I am trying to list all the projects that are overdue. File URL https://www.dropbox.com/s/28atfuxvwe5xstl/Test.xlsx I get the count of over due projects from =COUNTIFS('Master List'!$G$2:$G$60,">=6",'Master List'!$G$2:$G$60,"<150") - This is...