sum(summary()) for groups with varying number of items

897 viewsFormulas and Functions
0

I have a matrix with groups of items for which I want to do sums. The groups have different numbers of items, so a category won’t work.

Currently,  I create a single forumula for each group. Grp-Yr1.Total = sum(summary(Grp-Yr1)), Grp-Yr2.Total = sum(summary(Grp-Yr2)) etc. Overtime the number of formulas has increased as I’ve added new Groups of items. I’ve thought there should be a way to do this with a single formula. Well, this weekend I tried to do that, without success.

There’s probably a simple way to do this but I couldn’t find it. Does anyone have an answer.

Thanks in advance

The system wouldn’t allow my model to be uploaded so here’s an image of the matrix.

Tahir Answered question July 9, 2023
0

Hi lyledp, one way to solve this problem would be adding a new item to calculate cumulative values for each group with a single formula. Then you will not need sum summary items and formulas at all. Let me know if it would work for you, I can try to model it for you.

Tahir Answered question July 9, 2023
You are viewing 1 out of 4 answers, click here to view all answers.

Latest Questions