Help with SUM formula that totals cells adjacent to specific text...

Hi all.

I'm not sure if this is possible but it doesn't hurt to ask, right?

I'm trying to create a formula that can work as follows:

IF (CELL RANGE) = X, THEN SUM (CELL RANGE) OF CELLS ADAJCENT TO X

So for example, I'm looking for a formula that can total all of Mike's hours from the hour column at any point that his name is added to the employee column.

this is as far as I've gotten =IF(CELL RANGE)="MIKE",

Any help would be greatly appreciated.

Thanks,

Michael