Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array not working correctly Returns FALSE on second part
The below array I am working on is having a problem with the scond part. The
cell is returning false. The first part works correctly when "All" is selected in my list box which triggers the first part, but when I select a specific region, the cells returns FALSE. Usually the array just doesn't work if there is a problem so I am not sure how to interpret this. I have checked the standard items that can cause problems with arrays. Specifically, name range size are equal. Thanks =IF('Dashboard-Sales'!$A$6="ALL",SUM(IF($AM3&Key!$B$2&Lists!$I$3= Win_Probability&CloseMonth&C_F_U_R__Blank,Total_Co ntract),SUM(IF($AJ3&'Dashboard-Sales'!$A$6&Key!$B$2&Lists!$I$3=Win_Probability&Re gion&CloseMonth&C_F_U_R__Blank,Total_Contract)))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with array equations | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |