Replicate Countits/Sumifs/Pivot from Excel in Alteryx

[ducanhledao]

Hi Alteryx Community,

I would like to replicate the yellow highlighted formulas in Excel to Alteryx. Hope to receive your help. 

The tasks I need to do is highlighted yellow.  Here are the tasks: Here are the formulas/Pivot table results in Excel I tried to replicate in Alteryx

Thank you for your help. I have attached the excel file if needed. 

[echuong1]

This can be achieved with a series of filters and summarize tools. I'm not sure I understand what you're looking for with Task 3, but the general process applies. I've replicated tasks 1 and 2 in the attached example. The bottom stream is what I believe task 3 should be.

I also added a record ID and sort to help visualize the data a little better as you're working through the process, but these are not necessary.