Hello, I have the attached spreadsheet with a formula to return total cost of sales, what I need is for it now is to return under the 'Gallery Commission @ 45%' under the Monthly Art worksheet JUST what is in the column V of the 'Art Log' worksheet - ie the gallery commission of 45% and not the total sales which it is doing now!
Can anyone help with this?
ThanksHELP.xls
Hi n1kk1,
See the attached file and let me know if this fulfills your requirement.
Some point to mention here:- Dates in column N are all Januray and I have picked up the artist wise profile.
Feel free to get back in case of any questions.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
I am not able to understand your question. Maybe you could try explaining it again. What do you need to be corrected?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi
Do you mean in C19
Would you like to update your details so that we can see which version of Excel you have and your location. If you have XL 2007 or later your formulae could be simplified and knowing your location can help when thinks like date arithmetic and other locale variables are involved.
Please Login or Register to view this content.
Last edited by Richard Buttrey; 01-16-2012 at 08:48 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks dilipandey that's exactly what I am looking for!Originally Posted by dilipandey
you are welcome n1kk1.
Cheers
Regards,
DILIPandey
<click on below 'star' if this helps>
@ n1kk1
Hi,
Don't forget to update your details when you get a moment.
Rgards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks