Search results

I have data that is labeled as below: Year Service Price 2018 Wash 10 2018 Pick Up 20 2019 Wash 15 2019 Pic Up 23 I want a subtotal/total that will add the total price for year 2018. I have tried =iif([subform].[form]![year]="2018",sum([subform].[form]![price]),)...