Hi there,
Is it possible to combine the sumbycolor function and hlookup?
Here is my data file - https://ibb.co/gkdMYw
Summary sheet - https://ibb.co/h3tG0b
I'm trying to dynamically calculate the sum for a given month/project/team. So in cell C4 I'd like to calculate the total for Team B for the green cells by looking up the whole table.
Thanks
Is it possible to combine the sumbycolor function and hlookup?
Here is my data file - https://ibb.co/gkdMYw
Summary sheet - https://ibb.co/h3tG0b
I'm trying to dynamically calculate the sum for a given month/project/team. So in cell C4 I'd like to calculate the total for Team B for the green cells by looking up the whole table.
Thanks