help with SUMIF

[jasmine6]

Hi all, Is there a way to transform this table into one in this format with these columns? thanks for the help - please let me know if you need further details

[ChrisTX]

Use a Summarize tool with Group and Sum functions.  Then a Cross Tab tool to change the rows to columns.

You may get more help if you post your input and desired output in table format (not screenshots).

Chris

[CoG]

I agree that sharing sample data will make providing assistance much simpler. Even just copy-pasting what you would have taken a screenshot of will provide useful information to work from. This problem does seem fairly simple use case for the Cross Tab Tool although the provided workflow will require a little extra work on your part to get the row groups (Retail 0/Retail 1 + FAB/MFN, but I have full confidence in you!):

Happy Solving!!!

[jasmine6]

Hi Chris, Apologies - thanks for letting me know ive now attached my inputs and desired output table form