Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. Sorry if picture is too big, thanks.
![]() |
#2
![]() |
|||
|
|||
![]() Quote:
=SUMIF(E:E"0") Loss: =SUMIF(E:E,"<0")
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel profit and loss help | New Users to Excel | |||
CALCULATE PROFIT/LOSS | Excel Worksheet Functions | |||
income and profit/loss as a percentage | New Users to Excel | |||
format of profit & loss a/c | Charts and Charting in Excel | |||
Profit and Loss Formula | Excel Worksheet Functions |