Hello all,
I am preparing sales and stock register for my small shop. Kindly help me to put relevant formula to solve as i required. Kindly find the attachment in the Sales book Jan-Sales sheet the highlighted cell to be updated automatically by quantity as well as the sales value in a particular date coloumn. Or kindly share like the same sales and inventory report with you.
Hope i will get solution from the experts.
Thanks
Gerom-E
Last edited by geromio; 02-14-2013 at 04:47 PM.
Hello All,
Kindy help me to make the formula
Gerome-e
Hello all,
finally i have concluded with =SUMPRODUCT(--('Master Sales'!$B$4:$B$31=$E$3),--('Master Sales'!$E$4:$E$31=B$5),'Master Sales'!$H$4:$H$31c
I required to applicable the above formula applicable in all cell kindly help me to drag or copy perfectly. ( now if i drag it is not applicable for the same row)
Thanking you,
Gerom-E
i think this part
--('Master Sales'!$E$4:$E$31=B$5), should be $B5 -fill down formula using fill hande
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you vlady
It is applicable.
With regards,
Gerom -e
You very much welcome,thanks also. if you have no further concern with this thread can you mark this as "Solved". thanks.
How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.
Hello All,
Again I have open the solved thread. The Sumproduct formula is showing error in cell. Earlier it was worked perfectly now i unknowing the same . Kindly help me to solve the issue.
Kindly requesting you to go thru the herewith the attached workbook i required the purchase, sales, and stock quantity and the value to be updated automatically if I enter the data in Purchase sheet. Kindly help me is possible to make it easy other than i used formulas to complete my requirement.
Thanking you,
regards,
Gerom-E
I found on Master Sales column N27 and column G27 contain #N/A, and on Purchase too.
change your formula on Master Sales on N and G with this:
Please Login or Register to view this content.and for sheet purchase that contain vlookup, add =IFERROR(Vlookup(......),""), this will remove the error message.Please Login or Register to view this content.
Regards,
SDCh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks