profit and loss

  1. J

    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. J

    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. V

    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. M

    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...

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top