Sumbycolour and hlookup

[d438a1]

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

 

[mart37]

What is the condition for the green cells?

 

[d438a1]

Sorry, not quite sure which bit you're referring to?

 

[FDibbins]

1. I am unable to access file-hosting sites, so I cannot see your file.
2. There is no native excel function called sumbucolour, so maybe that is a UDF?
3. Where the colors applied through Conditional Formatting or manually?
4. This code may help...

Sum by Colors	Function SumColor(rColor As Range, 	
		
	rSumRange As Range)	
	''''''''''''''''''''''''''''''''''''''	
	'Written by Ozgrid Business Applications	
	'www.ozgrid.com	
	'Sums cells based on a specified fill color.	
	'''''''''''''''''''''''''''''''''''''''	
	Dim rCell As Range	
	Dim iCol As Integer	
	Dim vResult	
		
	iCol = rColor.Interior.ColorIndex	
	For Each rCell In rSumRange	
	If rCell.Interior.ColorIndex = iCol Then	
	vResult = WorksheetFunction.Sum(rCell) + vResult	
	End If	
	Next rCell	
	SumColor = vResult	
		
	End Function