Another possibility is the value corresponding to the one in T28 (in
column D) was accidentally made a Text value at some point.

Scott

Dave F wrote:
I don't get a div/0 error.

I used your formula and have the following values in the following cells:

T28: 0
D12: 4
A11: 2

I do, however, get a div/0 error if column D doesn't contain any data.

Dave
--
Brevity is the soul of wit.


"daven123" wrote:

Hi. I have an array where if a certain value (in cell T28) matches an entry
in column A of array A3:D82, it returns the corresponding value in column D.
The formula is:
{=AVERAGE(IF(T28=A3:A82,D3:D82))}.

This formula has worked great up until today. But today T28 corresponded
with a value more than half way down the array, and the array formula returns
Div/0. I know that the equation is correct because if I change one of the
higher rows to the same number, it again works correctly.

This surprises me since my table is not that large. Anyone ever run into
this problem and/or a solution!

Thanks!