Community archive

Ask something
Discussion Locked

To sum only visible cells, in EXCEL

0 helpful
0 replies

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, Excel.
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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.