# Apply a function in a criterion in Excel Suppose I have in the column `A` a list of integers and I want to summarize them in `B1`. Then I can simply write `=SUM(A:A)`. Suppose I want the sum of integers less than 10, so I can write `SUMIF(A:A,"<=10")`. What if now I want to add the integers that are perfect squares?

I could always make a column `C` with in the first cell (`C1`) `=INT(SQRT(A1))=SQRT(A1)`, then `=INT(SQRT(A2))=SQRT(A2)` and so. Then I can probably write `B1`, Something like `SUMIF(C:C,"TRUE",A:A)`, and then proceed to hide the ugly column `C`.

But is there no simpler and more orderly way of doing this? I can't seem to find a way to apply a function in a criterion. If for example `@x` they were a placeholder name (a variable) for the value in which the criterion is applied, you could write `"@x<=10"` for `"<=10"`but more usefully, I could write `"INT(SQRT(@x))=SQRT(@x)"` directly instead of making a `C` column as before. My question is then

Is there a simple way to create such useful criteria? 