I did according to the answer given by Mr Sachin but that is not working so
I would like to draw the attention of Mr Sachin once again please check the
attachement what's wrong i have done.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
I have applied the formula but not working, you may see the result in the
attachment.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use
*Hi, Use below code for the same .:*
*Function SumByColor(CellColor As Range, rRange As Range) *
*Dim cSum As Long Dim ColIndex As Integer ColIndex =
CellColor.Interior.ColorIndex For Each cl In rRange If
cl.Interior.ColorIndex = ColIndex Then cSum = WorksheetFunction.SUM(cl,
cSum) End If