SOLVED

New Contributor

# 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

5 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

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

=SUMIF(namerange, "MIKE", hoursrange)

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

@MNMAGEEpfa...I hope it resolves the issue.

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

Working perfect. Thank you!

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

Thanks @jitinm The formula that Hans posted worked for what I needed.

Great !