whats wrong with this syntax?

[amien]

SUM(IF(
Bird = 'Eagle' AND
WILDMATCH(Food , '*All_*')
,Value))

This Works...

Doenst Work

SUM(IF(
Bird = 'Eagle' AND
WILDMATCH(Food , '*All_*') AND

COUNT(TOTAL <Kind> Country) = 2
,Value))

Last Exp gives a problem, What i'm i missing at the syntax?

[disqr_rm · Accepted solution]

You cannot do nested agreegration unless using AGGR. Try playing with AGGR function. Otherwise you would need to adjust in your script and have new field, which could be a count of County groupped by Bird and the Food, based on what you are trying to do.