Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Either using something like
=Sum( If( ColumnA = 'Group A', ColumnB))
or using set analysis:
=Sum({<ColumnA = {'Group A'}>} ColumnB)
Similar to get the filtered sum for ColumnC.