I have an issue that I don't know is possible to do without doing it by hand. Please open the excel file before proceeding.
I have a list of parts that are classified by component. The fields BXZ,ROAD,STUNT,CRUISER are boolean not actual part counts. They are 1 if that part is needed for that component for that model or 0 if not. Some parts are multiuse.
To the right I have a "complexity matrix". I can use sumif and count if to get total part complexity and permodel complexity. the problem comes when I need to bucket to models together. I can not just add them because of the common parts. I have included the correct answer just by counting them and typing it in myself.
What I need is a forumula/method for figuring cells q3 and r3 out correctly without doing it by hand.