Array Formula returns error but only for specific columns
I am using an array formula to pull percentages for a range of numbers. Here
is the problem. The formula works fine for the majority of values i am
returning; however, when i reference certain columns in the secondary
document (the one i am pulling data from) the formula returns an error. It
has to be a format error, because when i delete the values in that row and
replace them with generic numbers the error is fixed, even when i delete all
the values and just leave the cells empy i at least get a div error instead
of a #Value error. I have tried everthing i can thing of as far as
reformating the data, but to know avail. Here is the formula i am using.
=SUM(('Austin Direct MFS'!$A$3:$A$17158=B2)*('Austin Direct
MFS'!$A$3:$A$17158<=C2)*('Austin Direct MFS'!$F$3:$F$17158))/SUM(('Austin
Direct MFS'!$A$3:$A$17158=B2)*('Austin Direct
MFS'!$A$3:$A$17158<=C2)*('Austin Direct MFS'!$D$3:$D$17158))
'Austin Direct MFS' is the secondary data sheet where all my value are
contained. This formula is in the first column i am running. The error
appears when i the above formula 'Austin Direct MFS'!$D$3:$D$17158 is
replaced with 'Austin Direct MFS'!$E$3:$E$17158. Both columns D and E
contain the same number of values. Can anyone help me out.
|