Hi,
would anyone know why doing a sumif on a range taken from a Showcase Query would bring back #value?

Ie. Showcase query is on range sheet1 A1:B3
If i do a sumif on that, it returns a linkedarea1 instead of the range and returns #value
If I do a sumif on the range greater than A1:B3 (ie A1:B1000) I get the correct answer.