how to sum total between at the space rows ??

[jayshing]

Hi all brother

I have some question how to auto sum at between of space rows ?

some example of the following picture

sum001.png

and the result is

sum002.png

Thanks you all !!

[alansidman]

Use the built in Sub Totals function found on the Ribbon on the Data Tab

https://support.microsoft.com/en-us/...e-b0a3d4a52b3a