Page 1 of 1

Need help creating Profit/loss summary

PostPosted: Wed Jan 23, 2019 5:12 am
by Hass1
Hi everybody

I have spent couple of days searching and trying, but couldn't achieve my goal.
It will be extremely helpful if anyone can explain me how to create or create template for me according to my requirement.
Sorry I am not expert in formulas. :ucrazy:

>>we assign "stock number" to each product.
>>incomes and expenses of each stock are mentioned in same column as " stock number".
>>in a separate sheet, I created Profit/Loss summary for each unit separately.

Target : I would like to just type "stock number" and all related incomes and expenses appear in profit/Loss summary Automatically.
This is what I want to do.

profit loss issue.jpg


profit loss summary screenshot.jpg


Please help

Thank you

Re: Need help creating Profit/loss summary

PostPosted: Wed Jan 23, 2019 8:24 am
by RusselB
Welcome to the Forums.
Regretfully, on my machine at least, your pictures are too small to be of any real use.
You obviously found how to attach a file, so I'm going to ask that you attach your actual working spreadsheet. Anonymize the data if you feel the data is sensitive.
Please note that there is a 128 k file size limit on the forum. If your file is bigger than that, then please upload it to a file sharing service, like Dropbox, MediaFire or Google Drive.
If you upload it to a sharing service, post a link to the file so that we can actually see what you are working with.

Re: Need help creating Profit/loss summary

PostPosted: Thu Jan 24, 2019 11:41 pm
by Hass1
RusselB wrote:Welcome to the Forums.
Regretfully, on my machine at least, your pictures are too small to be of any real use.
You obviously found how to attach a file, so I'm going to ask that you attach your actual working spreadsheet. Anonymize the data if you feel the data is sensitive.
Please note that there is a 128 k file size limit on the forum. If your file is bigger than that, then please upload it to a file sharing service, like Dropbox, MediaFire or Google Drive.
If you upload it to a sharing service, post a link to the file so that we can actually see what you are working with.


Hi @"RusselB"
Thank you very much for taking out time to write that message.
I had hard time reducing image size (in KBs) but keeping it as a bigger picture.
So finally I uploaded ODS file to sharing server and link is mentioned below.

https://1drv.ms/x/s!Aj93trc7rvY6gREpfIccNe__sQKQ

I will be greatly thankful for the favor to solve my issue.

Thank you

Best Regards

Re: Need help creating Profit/loss summary

PostPosted: Sat Feb 09, 2019 1:04 am
by Hass1
Hello Everybody,
Good day

Can Anyone please help with above request?
It will be so nice of you.

Thank you