Need Help with Creating a Custom Formula

[Matthew Roy]

I am trying to create a formula or function that will be able to see if a cell is checked x then it will tally up the number next to it and then add all the cells with the x and give me an amount. 

[#2]

Have a look at the SUMIF function, it should do what you need.