Help with Formula

[lac]

Hello, Can someone please help? Looking for a formula that will sum up column H totals using a combination of columns c,d,e,f as the lookup criteria. 

[DavidP · Accepted solution]

Hi @lac 

I'm not sure what your lookup criteria are, but it sounds like you should use the Summarize tool with Group By and Sum arguments

[nitin_l · Accepted solution]

• Concatenate the Columns C,D,E and F
• Summarize the total grouped by Concatenated column
• Used "Find and Replace" Tool to lookup the values using concatenated column
• Using "Select" tool, remove the concatenated column but keep the new total column

[Qiu]

@lac 
If I understand your intention correctly, we can use a Summarize Tool.

[lac]

Brilliant. Thank you