1 Reply Latest reply: Sep 4, 2018 12:35 PM by Stefan Wühl RSS

    Sumif equivalent

    Michael Bloom



      I know it might have been asked several times but I'm struggling to find an answer.


      I'm trying to translate this into a formula:


      Column A contains multiple groups (Group A, Group B, Group C)

      Column B contains numeric data (figures in EUR)

      Column C contains time data (a certain number of hours)


      I'm trying to have a formula that says:


      sum of column B for Group A / sum of column C for Group A


      How would it translate into a formula?


      Thank you for your help!!