I have a problem and I can't quite figure out how to do it.
What I am doing is a commission spreadsheet to calculate my own commissions. Each loan is on a row. One column is "commission" where I I Have a dropdown list selecting whether the loan is an "A", "B", or "C" commission loan. What I want to do is have one cell on the page that adds all the "A" commissions together. Another for the "B" commissions and then yet another for the "C" commissions. This is a bit beyond my experience with Excel.
I would also like to add some "If" statements but I am unsure how to go about them. It looks like there are only really two things I need done that should be quite simple for someone who knows how to do it. The process is repeated in a few different places. I have attached the excel worksheet and added comments to the fields that I need addressed so you know exactly what I need to have done. Thanks!