Excel profit and loss help
 

Hi, im quite new to excel, iv stared selling things and wanted to keep track of my losses and profits, iv made a spreadsheet and so far its ok, any numbers under 0 so with a minus will come up with a red box and if a profit comes then a green box, i have a total profit and total loss box i want all the minus numbers to be added up and tell me all my loss and then all the profit boxes to be added up in the total profit box. i have taken a screenshot and the vales i have used are just for example, thanks for any help. could you explain well please and if so , somthing to copy and paste, much appreciated.

Answer: Excel profit and loss help
 

Hi there! I'd be happy to help you with your profit and loss spreadsheet in Excel.

To start, you'll want to make sure that your spreadsheet is set up with the appropriate columns and rows. I recommend having a column for the item or service sold, a column for the cost of goods sold (COGS), a column for the selling price, and a column for the profit or loss.

Next, you can use conditional formatting to highlight any negative numbers in red and any positive numbers in green. To do this, select the column with your profit or loss numbers, go to the Home tab, and click on Conditional Formatting. From there, select Highlight Cells Rules and then Less Than. In the box that appears, enter "0" and select the red fill color. Then, repeat the process but select Greater Than and enter "0" to highlight positive numbers in green.

To calculate your total profit and loss, you can use the SUM function. In a cell below your profit or loss column, type "" and then select the range of cells with your negative numbers. Close the parentheses and press enter. This will give you the total loss. Repeat the process for your positive numbers to get the total profit.

Here's an example formula for the total loss: "" (assuming your profit or loss column is column D and your negative numbers are in rows 2-5).

And here's an example formula for the total profit: "" (assuming your profit or loss column is column E and your positive numbers are in rows 2-5).

I hope this helps! Let me know if you have any further questions.

1. Set up your spreadsheet with appropriate columns and rows
2. Use conditional formatting to highlight negative numbers in red and positive numbers in green
3. Use the SUM function to calculate total profit and loss

Sumif!
 

Hello!

To add all the positive numbers, we can use the SUMIF Function in Excel.

To use SUMIF:

=sumif(range, criteria, sum range)

in this case, the criteria is in the same range as the sum range, so:

=sumif($E$2:$E$31,Criteria,$E$2:$E$31)

then For the criteria:

=sumif($E$2:$E$31,"<0",$E$2:$E$31) for the negative numbers
=sumif($E$2:$E$31,"0",$E$2:$E$31) for the positive numbers

we use the $ sign so that regardless of what cell we put this in, the range will not change.

Hope this helps!