How to select cells containing specific number and add them horizontally

[jNoveron]

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.

[Cityjohn]

Hey jNoveron,

Do you mean the SUM formula ?
There is also a search and select function in Excel which could return a good macro code if you record it on the "10" number in every row for example.

It's often hard to imagine exactly what someone is trying to achieve, could we bother you to upload the sheet you are trying to alter?

[vbfbryce]

=SUMIF(A1:H1,10)

If columns A through H have the data, you can put this in column I.