Sumifs with Color and statement as criteria

[Raghava@rock]

Hi Team,

I am recahing out to you to see if there is availability to do sum based on Color and annormal criteria . attached is the example for your reference.

Thanks in advance for you help.
Raghava

 

[Asheesh]

what is the other criteria

 

[Raghava@rock]

Hi Asheesh,

The other criteria is resource & Fruit in my provide example file.

 

[Nebu]

Hi:

Use the following UDF

Function SumColor(CColor As Range, rng As Range)
Application.Volatile

Dim CellSum&

CIndex% = CColor.Interior.ColorIndex

For Each cl In rng
  If cl.Interior.ColorIndex = CIndex Then
    CellSum = WorksheetFunction.Sum(cl, CellSum)
  End If
Next cl

SumColor = CellSum

End Function

Thanks