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 (
=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
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
"<=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?