Sumif - Colorindex = 37

I have some data where I have colored certain Values.

I want to write a code that would Sum only if the Color Index is 37.

I have attached the sheet as well as the code.

Can anyone clarify what is wrong?

Code =

Please Login or Register  to view this content.

Hi,

I have changed your code as follows :

Please Login or Register  to view this content.

Works!! Thank you..

Glad i could help,

Please mark this thread as solved if you are satisfied with the solution provided.