Referring to arrays and circularity produced by it
 

I am having a circularity problem, when I am referring to a cell with
an array function in it (ex. sumif) in my worksheet. Once I type in
formulas (that give the same answer as array formulas) instead of
arrays, circularity disappears. Has any of you had this problem
before or know how to solve it?