|
Senior Member
|
|
Location: Philippines
Posts: 161
|
|
Quote:
Originally Posted by Austen
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.

|
Profit:
=SUMIF(E:E"0")
Loss:
=SUMIF(E:E,"<0")
__________________
Asobi Wa Owari Da
|