I have a list of sponsorships at various price points in one tab and I have them linked to my individual clients. I want to create various packages to include several different sponsorships. Is there a way to calculate the total of the individual sponsorships into a package amount total in my master sheet?

For Example:


Package A for Client Y has 4 sponsorship options. I’d like for it to be able to display the selected sponsorships AND the total of the combined levels.

THANK YOU!