Hide rows, auto sum adjust atomatically?

smscheung

New Member
Joined
Mar 14, 2019
Messages
22
For example
Row1
Row2
.
.
.
Row10

I set a formula adding the value of these 10 rows. Is it possible that if I do some sorting, lets say only 1,3,5,7 rows, is there an auto sum formula that will adjust automatically only summing those 4 rows?

Thanks a lot.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,090,045
Messages
5,412,026
Members
403,409
Latest member
IHRAcer

This Week's Hot Topics

Top