Hope you can help me out with this one. I have a sheet which contains rows of data. Each column has a name and the column right next to it contains a number. This pattern continues for about 8 columns.

E.g.

Name, #, Name, #, Name, #, Name, #

I need to build a formula that will say If Name = " ", then count # in the next column.

E.g.

Alex, 8 - So the formula will know that if the "name" column contains the text "Alex" it will then count the number 8 which is posted in the next column.

Please keep in mind that I will need this formula to eventually sum up all numbers where Alex (or different names) appears. Any help or guidance you can provide would be greatly appreciated.

Thanks.