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

    Sumif equivalent

    Michael Bloom

      Hi,

       

      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!!