Because using homomorphic encryption you can encrypt sensitive information (like a numeric column) and still do arithmetic operations on it while it's encrypted.
For your specific case of summing up values in a numeric column of a database, homomorphic encryption is indeed applicable. If you encrypt each value in the column using a homomorphic encryption scheme, you can then sum these encrypted values. The result of this operation will be an encrypted value that, when decrypted, will reveal the sum of the original plaintext values. ypes of Homomorphic Encryption
There are mainly three types of homomorphic encryption:
Partial Homomorphic Encryption (PHE): Allows only one type of operation (either addition or multiplication) an unlimited number of times. An example is RSA.
Somewhat Homomorphic Encryption (SHE): Allows both addition and multiplication, but only a limited number of times.
Fully Homomorphic Encryption (FHE): Enables both addition and multiplication on encrypted data an unlimited number of times. This is the most versatile form but also the most computationally intensive."