jjeong1210
New member
- Local time
- Today, 00:36
- Joined
- May 18, 2018
- Messages
- 2
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]),)
But it would return #error as result. Is there something wrong with my formula?
Any help are appreciated!
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]),)
But it would return #error as result. Is there something wrong with my formula?
Any help are appreciated!