Summarize with identifiers from a different file

[HafeezA]

Hello, I am trying to replicate a SUMIFS  formula that uses 2 unique identifier fields from another file to group values values form a second file. How do I go about doing this ?

File one consists of key field and group field.

File two consists of a key and group field too and also the desired "price"  field.

How do I use the key and group fields in file one to summarize the "price" field in file two. Will a join tool work ?

[atcodedog05]

Hi @HafeezA 

Can you provide some sample input and expected output it will help us get a better understanding.

[HafeezA]

File one consists of key field and group field.

File two consists of a key and group field too and also the desired "price"  field.

How do I use the key and group fields in file one to summarize the "price" field in file two. Will a join tool work ?

[atcodedog05]

Hi @HafeezA 

Here is how you can do it.

Workflow:

1. Use join tool to map groups

2. Using summarize on groups.

Hope this helps : )