# profit and loss

1. ### How to calculate a sum total based on certain criterias

Hello, I need help with a formula that can calculate the sum total based on a text in a cell. -I am addressing the Net Profit column (J). -Calculate the sum to be positive if Buy/Sell/Win/Lose (column C)) displays a BW or SW. -Calculate the sum to be a negative if Buy/Sell/Win/Lose displays a...
2. ### When compare doesn't mean compare! How do I create a profit and loss sheet from 2 separate sheets?

Hi, I have trawled all the forums and googled till I’m blue but I’m losing my decorum and don’t know what to do! Please can you help me solve what I think should be a really simple profit and loss spreadsheet problem? Every time I look up ‘compare spreadsheets’ I find solutions which only...
3. ### Calculate Biggest Profit & Loss Day

So I have a range of bets that I would like to summarize by having a cell display the most amount of money won and another showing money loss on a single day and for it to constantly calculate the biggest amount. What would be the best approach for this? The data is formatted like below...
4. ### monthly profit

Hi I've been stuck for ages and cant seem to figure this problem out in my head even though i think its a fairly simple question!! My situation is as follows: i have a debt amount of £20.00 monthly i earn £10.00 i want to show a row that shows the amount of profit in each month if the debt...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back