Community archive

Ask something
Discussion Locked

To sum only visible cells.

0 helpful
1 reply

by pradeep_chk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm unable to sum only visible cells.
Let's say rows 2,4&6 are hidden, and i select rows from 1 to 10, for me i am selecting only rows 1,3,5,7,8,9 & 10 which are visible. But when i make a sum of them the data in hidden rows are also summed.
Please help.

1 reply

by timwalsh

The fact the a cell is hidden or visible is a format issue. There are no operations in Excel (that I have found) that use the format of a cell as a condition for inclusion or exclusion in an operation. Even though the cells can't be seen, they still have valid contents and are included in the sum. You will have to specify what specific cells you want included in the sum.

This discussion is closed to new replies.