SOLVED

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

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3143539%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EHelp%20with%20SUM%20formula%20that%20totals%20cells%20adjacent%20to%20specific%20text...%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3143539%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20all.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20if%20this%20is%20possible%20but%20it%20doesn't%20hurt%20to%20ask%2C%20right%3F%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20formula%20that%20can%20work%20as%20follows%3A%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EIF%20(CELL%20RANGE)%20%3D%20X%2C%20THEN%20SUM%20(CELL%20RANGE)%20OF%20CELLS%20ADAJCENT%20TO%20X%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESo%20for%20example%2C%20I'm%20looking%20for%20a%20formula%20that%20can%20total%20all%20of%20Mike's%20hours%20from%20the%20hour%20column%20at%20any%20point%20that%20his%20name%20is%20added%20to%20the%20employee%20column.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ethis%20is%20as%20far%20as%20I've%20gotten%20%3DIF(CELL%20RANGE)%3D%22MIKE%22%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346731i0B8E35521471F157%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22MNMAGEE_0-1644418374167.png%22%20alt%3D%22%5C%26quot%3BMNMAGEE_0-1644418374167.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMichael%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3143539%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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",

MNMAGEE_0-1644418374167.png

 

Any help would be greatly appreciated.

Thanks,

Michael

 

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

@MNMAGEE 

=SUMIF(namerange, "MIKE", hoursrange)

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

Working perfect. Thank you!
Thanks @jitinm The formula that Hans posted worked for what I needed.