Complicated Conditional Formatting Help Needed Please

Hello, I am trying to make a spreadsheet so that i can track some sales. I sell CD's for either one, two, or three dollars. I have developed the spreadsheet you see attached. I am able to have separate columns and totals for my cash and credit transactions, however i need another formula. I need a way to track the total profit from $1, $2, and $3 CD sales. On the right side I have the way i need it to look but I do not have the formulas. I think I need a conditional statement but I have no idea how to go about it. I would immensely appreciate help as I am working with a limited amount of time. God bless you all.

See yellow cells in the attached.

Worth pointing out this is nothing to do with conditional formatting as the title would suggest.
It uses SUMIF as a conditional sum is needed.

BSB

Hi daniel_the_doctor,

The SUMPRODUCT formula will calculate what you require. I've added the formula to the attached document.

Regards,

Snook

Thank you so much! you have no idea how much I appreciate this!

Hi Daniel,
Please mark thread as solved on the top right of the forum. Didn't see what others have, but I have also used the sumif (see attachment). Thanks, -Newb