shortcut - Select multiple single cells in excel

Question

Is there any way to select multiple single cells at once?

The rows are grouped as per the image below. So of course when I ctrl+arrow up it takes all the cells (including the ones hidden inside the group)

Is there a way to quickly (with a shortcut?) select single cells as per below?

question from:https://stackoverflow.com/questions/65941585/select-multiple-single-cells-in-excel

Answer 1

The only way is to apply subtotal function and function number 109 to sum the values.