Sum of cells colored using conditional format

Hi friends,

I would appreciate a bit of help with my below problem.

I have a table in which I have conditionally formatted certain cells.
Now I want to sum the conditionally formatted cells (that are colored distinctly) both row-wise and column-wise i.e. the sum of colored cells.
I tried applying a vba program for adding the sum of colored cells but it would not work on the conditionally formatted cells.
Could you please guide?

Thanks in advance.