SUMIFS based on a few conditions

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!

Book1.xlsx

Datasets

Custom Tools

Transformation

Help

Accepted answers

atcodedog05

Hi @Justanaccount

You can use join tool to get only those mapping

Hope this helps : )

sumif.yxmd

All comments

atcodedog05

Hi @Justanaccount

You can achieve this use summarize tool.

Workflow:

Hope this helps : )

sumif.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15874

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703