u/Far-Organization6349

Hi Great people , am trying to sum cells on a filter column e.g SUM(A5,A12,A20,A31) however when removing the filter the sum picks the whole column instead of the picked cells above , will truly appreciate your help with this.