I would to sum selected range of column simoultaniosuy, lets suppose in below data i would like to take sum of column "data" from a till c , and then again a till c simoultaniosuy . Can anyone please tell me some suitable formula i can use.
id data
a 1
b 4
c 6
a 7
b 7
c 8