I have a sum if conditional calculation that looks like this in the formula bar:
{=SUM(IF(($F8:$F232="Canada")*($G8:$G232="Purple"),I8:I232))}
It copy/pastes perfectly fine to other cells and gives me the total of I8:I232 based on the conditional values in F and G. It works fine.
But if a make any change to the cell ranges, conditional values, or even click in the formula bar and press enter, the {} brackets disappear and I receive a #Value! error.
WTF ???
Bookmarks