Calculate total percentage

Question

Calculate total percentage

jm saf 166

Hi group!!!

How could I get the result of the query column, knowing that for each code I multiply the days by the percentage, add them and divide them by the total days
this is my sample data

Thanks in advance
Regards

Erin Ding-MSFT 4,476 Reputation points

2020-12-29T07:46:01.627+00:00

Hi @jm saf ,

Please refer to the formula given by HansV-7609.
I have done a little change on it.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Accepted answer

1 additional answer

Your answer

Erin Ding-MSFT 4,476 Reputation points

2020-12-29T07:46:01.627+00:00

Hi @jm saf ,

Please refer to the formula given by HansV-7609.
I have done a little change on it.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

HansV 966 MVP

Assuming that your data are in A2:C19, with headers in row 1, enter the following formula in D2:

=SUMPRODUCT(($A$2:$A$19=A2)$B$2:$B$19$C$2:$C$19)/SUMPRODUCT(($A$2:$A$19=A2)*$B$2:$B$19)

Then fill or copy down.

Erin Ding-MSFT 4,476 Reputation points

2020-12-29T07:42:37.473+00:00

Hi @HansV ,

Thanks for sharing~
There maybe something wrong when typing the formula here.
jm saf 166 Reputation points

2020-12-29T08:03:22.487+00:00

Hi Erin Ding

thanks for your contribution.
I had seen it when I saw the answer so I fixed it in Hans's formula
Regards

Answer 2

jm saf 166

Hi Hans!!

your reply has solved my problem.

Thanks for sharing your knowledge and for your time.

Regards

Share via

Calculate total percentage

1 additional answer

Your answer