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?