FG
💻 Software

How to obtain sum of square of all cells in a column in Excel

Fresh5 days ago
Mar 15, 202624333 views
Confidence Score0%
0%

Problem

In excel, my data is populated from Cell to in Excel. I want to obtain the sum of the squares from to . I could use a simple function . But this is too cumbersome to write and error prone. Is there a shortcut function that is similar to ?

Error Output

B1

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to obtain sum of square of all cells in a column in Excel

Low Risk

Use SUMSQ

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment