Help with a complex SUM(SUMIFS) formula calculating percentage of time please :)

[PMan22]

Hi everyone,

I wondered if anyone could help with the following formula:

=SUM(SUMIFS(J3:J4536,F3:F4536,{"ActivityA","ActivityB","ActivityC","ActivityD"},D3:D4536,"Name",B3:B4536,AU199,AI3:AI4536,{"CategoryA","CategoryB","CategoryC"}))/SUMIFS(J3:J4536,AI3:AI4536,{"CategoryA","CategoryB","CategoryC"},D3:D4536,"Name",B3:B4536,AU199)

I'm trying to find the total percentage of time an individual spends doing activities A, B, C and D by first adding up the minutes spent doing these activities (Column J is the minutes), and then dividing them by the total number of minutes observed (Categories A, B and C).

I've done the same formula previously and it worked perfectly, the only thing I've changed now is adding more criteria within the {} brackets but the error message says I am trying to divide by zero.

Any help very much appreciated!!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.