Sumifs Statement

[ShreyaSharma]

Hi ,

How to write this formula here in alteryx.

THanks

[Tony_Castillo · Accepted solution]

For combined criteria, filter the data by color and state. Then sum the total.

For the single red sum, use the summarize tool. 

[ShreyaSharma]

Already solved..Thanks

[ImadZidan]

Hello @ShreyaSharma ,

Here is an idea. I did not filter on the Blue or Red . In this case you can apply it for both.

If you just want for red, let us know or add a filter to do that.