SUMIFS based on a few conditions

[Justanaccount]

Hi everyone, 

First time coming to this forum and thank you in advance for the help! 

I am trying to sum total fees from the Data tab based on two criteria"1st Code"  and "Date" from the Condition tab. I didn't attach the exact data but this is very similar to what I have. I have created the sumifs formulas on the Condition tab to show the intended results. 

The thing for me is that there are many more instances based on which I need to sum the data (please see the condition tab) and the source data is enormous and includes the whole year. 

Any help would be greatly appreciated! 

[atcodedog05]

Hi @Justanaccount 

You can achieve this use summarize tool.

Workflow:

Hope this helps : )

[Justanaccount]

Hi @atcodedog05

Thank you for your response.

The results return all the summed data from the "Data Tab" however, that's not what I wanted to get as a result. I only wanted the workflow to return the sum for rows I listed on the "Condition Tab" aka in this file, I only want the workflow to return the total fees for 1234 for the month of January and the total fees for 1234 for the month of February. I do not want the flow to return total fees for anything else. 

[atcodedog05 · Accepted solution]

Hi @Justanaccount 

You can use join tool to get only those mapping

Hope this helps : )

[Justanaccount]

Thank you! It works great and saved so much of my time. 

[atcodedog05]

Happy to help : ) @Justanaccount 

Cheers and have a nice day!