Hello, please help me on this:

I'm trying to "select" the cells that contain a specific number (say "10" from an array of about 800 cells from 8 columns) and then sum them horizontally and output the result in a new cell on the same row of each row containing the identified cells.

So far, I'm able to change the color of the cells with the If then command, and have the selected cells (in a dim).

Please help me with this problem. Your help will be very much appreciated.