Hi all,
I cannot work this out at all, I would really appreciate your help.
The first image is my summary for June, so each day I want to be able to see how much I will be earning.
The second sheet shows the customers, how often their house is cleaned, the amount they pay and also the dates of their next 3 cleans. I'm only interested in Junes, and can adapt for other months.
I hope that makes sense with what I am trying to achieve.
Thank you in advance.
Attachment 522868
Attachment 522869
Last edited by E&E; 06-13-2017 at 02:21 PM.
E&E welcome to the forum
Looks like your images didnt come through?
Anyway, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for your response.Originally Posted by FDibbins
E&E welcome to the forum
Looks like your images didnt come through?
Anyway, Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
I have added the excel sheet with required info.
Hopefully it makes sense as to what I require.
This formula, dragged across the row will show how much you are making per day.
=SUMPRODUCT((Sheet2!$E$4:$G$28=C6)*(Sheet2!$D$4:$D$28))
You my friend are an absolute hero! Take some rep!
Glad to help! Thanks for the rep.
If this answered your question, please mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks