SUMIFS with Fill Color as a criteria

[plane2002]

Hi,

I'm looking for a UDF that acts as a SUMIFS formula but allows for fill color to be one of the criteria.

I've found many working examples of SUMIF type formulas that use the fill color as the only criteria.

In my instance however, I need a SUMIFS because I have additional criteria (i.e. vendor, Capital vs. Expense, etc.) that I also need to separate in addition to the criteria represented by the coloring.

Thanks!

 

[cyrilbrd]

Not sure if this would work for you:

Excel 2013
	A	B	C	D	E
1	color_range	hide		color	count
2		6			3
3		35			3
4		6			4
5		35
6		40
7		40
8		6
9		40
10		35
11		40
plane2002

Cell Formulas
Range	Formula
E2	=COUNTIF(B2:B11,ColorIndex(D2))
B2	=ColorIndex(A2)

 

[cyrilbrd]

Sorry, forgot to post UDF:

Function ColorIndex(CellColor As Range)
ColorIndex = CellColor.Interior.ColorIndex
End Function