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