SOLVED

Trouble with multi-column formulas while building allocation sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1750073%22%20slang%3D%22en-US%22%3ETrouble%20with%20multi-column%20formulas%20while%20building%20allocation%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750073%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20build%20a%20formula%20that%20will%20take%20the%20sum%20of%20certain%20data%20points%20when%20using%20a%20different%20column%20as%20criteria.%20I%20would%20like%20to%20be%20able%20to%20put%20a%20formula%20in%20J2%20that%20would%20add%20up%20the%20weights%20in%20column%20E%2C%20only%20if%20that%20same%20row%20is%20labeled%20%22I%22%20in%20column%20H.%20In%20J3%20I%20would%20like%20the%20same%20but%20for%20rows%20labeled%20%22E%22%20in%20column%20H%2C%20and%20so%20forth.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20that%20I%20could%20do%20this%3F%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22zachb32_1-1602002996398.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224469iA343D4CDCDFE53B9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22zachb32_1-1602002996398.png%22%20alt%3D%22zachb32_1-1602002996398.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1750073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1750450%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20multi-column%20formulas%20while%20building%20allocation%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750450%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F822239%22%20target%3D%22_blank%22%3E%40zachb32%3C%2FA%3E%26nbsp%3BOffering%20two%20alternatives%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1750692%22%20slang%3D%22en-US%22%3ERe%3A%20Trouble%20with%20multi-column%20formulas%20while%20building%20allocation%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750692%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi All,

 

I am looking to build a formula that will take the sum of certain data points when using a different column as criteria. I would like to be able to put a formula in J2 that would add up the weights in column E, only if that same row is labeled "I" in column H. In J3 I would like the same but for rows labeled "E" in column H, and so forth. 

 

Is there a way that I could do this?

 

zachb32_1-1602002996398.png

 

2 Replies
Highlighted
Best Response confirmed by allyreckerman (Microsoft)
Solution

@zachb32 Offering two alternatives attached.

Highlighted