I have attached a sample workbook - I am trying to use the aggregate function instead of Subtotal, because I have criteria:
I have tried several iterations of =AGGREGATE(9,3,Sales1*(Prod1="Ties"))
I am relatively new to the use of the function, it would be greatly appreciated if someone could help me solve the problem but also explain what I am doing wrong for future use.