do you need me to upload the spread sheet?
It is on its way, I highlighted the rows in green all the way accross. The two tabs that I am working on are recuring receivables and R1-A Joni Scott
I have been working on this for several nights and work full time during the day.. Please forgive me I did not mean to be rude... Thank you very much for trying to help me with this project. I have been having a tough time with it.
I dud the upload twice?? I am not home from work yet but will be in about an 40 minutes. I will send as soon as I am in house.
It is on its way, it looks like it went through and nothing was different than last time I uploaded a file. Please let me know asap if you got the file as I have been up since Sunday. I was waiting up this morning thinking you had the file.
I highlighted the rows in green all the way accross. The two tabs that I am working on are recuring receivables and R1-A Joni Scott.
I highlighted the rows in green all the way across The two tabs that I am working on are recurring receivables and R1-A Joni Scott.
did it come through? In the past I have worked with another gentleman but I had to pay for it as I was under time constraints. He actually helped start this document. I am about to crash as I older then you and can't stay up 48 hrs straight ;-) enjoy your youth!! I will be back on tomorrow and if i have to pay to ensure that we can get this wrapped up that won't be an issue. Please let me know.
Attachments are only available to registered users.
here is everything from the download page. I thought that was for me after we are done working on it.
http://wikisend.com/download/572488/ResMan Sales and Commissions Ver 4.xlsx
ResMan Sales and Commissions Ver 4.xlsx
sorry I am in meeting will that formula allow differentiation between march 2013 and march 2014?
when I put the formula in the cells that should have end now say value?
That is what I did as your formula was relevant to that row only. It did not fix the issue. I went recurring receivables>row 3 and put in "2" around the number representing the month which made the amount clear where it was fine before ?
I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the professional thinks that someone else might be a better match for your question. I've been working hard to find a new professional to assist you with your question, but sometimes finding the right professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.
Thank you, I was tied up in meetings all day yesterday and into the evening. I am a little bit older and can't stay up all night 2 nights in a row. I am still needing help and have not resolved my problem.
D3 contants the date the contract was signed.
N2 contains the month the commission is to be paid. The formula below works if the contract reflects a date where the day is on the 1st; if the contract reflects a sign date of 3/15/13 for example the formula does not assign the value needed.
Thank you I am past deadline and have to complete this today no matter what and do not want to manually enter amounts in the columns in white on all those spreadsheets.
Thank you for picking up my issue
Can I upload the file for you to view - in case I am not stating it correctly
Columns N:AK need to reflect in each row below the number of units as determined by the contract date. So column N will show any units signed into a contract for the month(column header)
No I don't need to account for the $.00 I need to pull over the number of units for that contract into columns N:AK. We calculate the commissions elsewhere. The number of units closed for each month determines the amount of the commission.
So I need to see the number of units in column E reflected in the appropriate month the contract was signed.
k, so all of the $ signs in N:AK are just formatting, you are just interested in the number of units,> YES
and only if the month heading matches the contract date? NO- I need it to match Month, YEAR. When I date a contract for the 1st day of any of those columns the units carry over just fine, but if the contract starts on any other day of that month the units don't cary over.
and all of the others months should be blank or 0? YES
yes regardless of day
I am on the R1-A tab for Joni and I don't see any formula changes?
oh no... we are trying to work on the yellow tabs only... I finished out the recurring on my own the night before. The tab tracks something different and explains why you were asking about amounts.. and i kept referencing units.
i thought it was in the previous emails. I am sorry- look at the joni tab and the need for month/day/year in columns N:AK