Hello! I figured this out before and accidentally cleared it a while back without noticing. For context, I am trying to find the total cost associated with ordering additional curriculum books.
In the form submitted, customers can select additional books for purchase at $45 for K-2nd and $60 for 3rd-6th.
I am trying to find the sum of:
multiplying the following columns by $45: Additional K English, Additional K Spanish, Additional 1st English, Additional 1st Spanish, Additional 2nd English, Additional 2nd Spanish
multiplying the following columns by $60: Additional 3rd English, Additional 3rd Spanish, Additional 4th English, Additional 4th Spanish, Additional 5th English, Additional 5th Spanish, Additional 6th English, Additional 6th Spanish
for a total cost to appear in "Additional Books Purchased:"
ex: 1 additional K Spanish & 1 additional 6th English would equal $105 in the additional books purchased column.
Any help is greatly appreciated!