Sumif equivalent

[Anonymous]

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

[swuehl]

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.