Google Sheets Editing

I have a google sheet that I'm using as a trading tracker and I need some help with it.
I basically have some text in one column and some values in another column
and I want the spreadsheet to do the following:
1. I have several columns with different titles
2. If the title is 'x' and If a certain text value is in a column 'y' then multiply the value in column 'z' by a value.
3. Then sum up these values to get a total in each column
4. Then create a chart for each column that shows the performance of a certain trade over time
5. These calculations need to be set up so they can handle further data entry in the columns that contain values.

I already have the data populated so you just need to create the formulas to get this to work.
This should be pretty easy for anyone that is familiar with Excel or Google Sheets.

Thanks!