SharePoint List Formula to show SUM of Column Values

%3CLINGO-SUB%20id%3D%22lingo-sub-1713465%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Formula%20to%20show%20SUM%20of%20Column%20Values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1713465%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%20I%20have%20a%20SharePoint%20list%20with%20the%20following%20column%20types%3A%3C%2FP%3E%3CP%3EPlant%20Location-Choice%3C%2FP%3E%3CP%3EWork%20Cell-Choice%3C%2FP%3E%3CP%3EPosition%20Cell%20Score-Number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20field%20that%20sums%20all%20the%20values%20Position%20Cell%20Score%20if%20Plant%20Location%3DPlant%202%20and%20if%20Work%20Cell%3DShaker.%20Better%20yet%20would%20be%20a%20formula%20that%20would%20sum%20the%20values%20of%20Position%20Cell%20Score%20if%20Plant%20Location%3DExample%20all%20combinations%20and%20if%20Work%20Cell%3DExample%20all%20combinations.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20this%3F%20Thank%20you%20all!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1713465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hello All, I have a SharePoint list with the following column types:

Plant Location-Choice

Work Cell-Choice

Position Cell Score-Number

 

I need to create a field that sums all the values Position Cell Score if Plant Location=Plant 2 and if Work Cell=Shaker. Better yet would be a formula that would sum the values of Position Cell Score if Plant Location=Example all combinations and if Work Cell=Example all combinations. 

 

Can anyone help with this? Thank you all!

 

Tom

0 Replies