How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I have been keeping a month by month log of sales to over 100

This answer was rated:

I have been keeping a month by month log of sales to over 100 accounts for the past 7 years. As an example, column A is account, Column B is year, etc. Jan thru Dec sales data are D through O, P total column. I then figure commissions using a cell iwth percentage of commission for my salesmen to the right using the same format.

Sheet A is the excel spreadsheet with the info.
Sheets B, C, D, etc are graphs of each accounts sales performance over the past years. Once I have done the charts, the cells and numbers in the sales data sheet no longer add into the totals.

I have never had this problem before and have been doing graphs like this for over 7 years. I it a huge, important amount of data. Can you help figure out why it is not working?



Hi John


Would you be able to send me that file so I can check it and try to fix the issue


Customer: replied 4 years ago.

Yes, see attached. this is one example of 10 different spreadsheets built in the same fashion for different factories we represent. I am assuming once you fix one, the fix will be the same for all. I need to send you the file in Outlook as I cannot see a copy/paste on this sheet. Will go out in a few minutes.

No we cannot use email here. Please go to and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.


If the file has sensitive information let me know before you upload it


Did you have any problems uploading the file?



Customer: replied 4 years ago.

No problems at all. I sent the download info to you about 20/30 minutes ago.. I will resend

Where the download link or File ID? (please see instructions in bold)





Customer: replied 4 years ago.

Got it thanks


I am looking at your description but I do not know when sheet all these columns and references are in (i.e. which is Sheet "A" and Sheet "B" etc)



Customer: replied 4 years ago.

Totals sheet, column for August


Can you just call me. I have to leave at 6:00 for a meeting.


Customer: replied 4 years ago.

More info so you don’t have to find every mistake.


Check cells:

K169, 449,669,879, 909,949, 979


These numbers are put into the cell, but do not capture in the totals by salesperson at the bottom of the sheets. Call me at XXX-XXX-XXXX with any questions.


John B

John this site does not permit contact by phone or email


Ok I see the columns that you are referring to.


Could you type 5000 in cell K169 and hit Enter, then tell me what value appears in cell AB169







I just updated my above message in line with the cell references that you gave me. Please look again at the updated message
Customer: replied 4 years ago.

did - AB169 works just fine. that is not the problem. Cells K1329 should add the $5000 to that total and does not. Cells K1299 should add the $5000 to the total and it does not.

Customer: replied 4 years ago.

The K cell references I gave you all have numbers entered into the cells. None of those numbers are showing up in the totals down at K1299, 1309, 1319, 1329, etc. As each salesperson is totalled, for whatever reason, the K cells noted are not adding into the totals

Damn I wish you would call me or give me a number. this is taking us both way too long

Customer: replied 4 years ago.

I have to leave. Am an officer in my little town and have a Selectman's meeting tonight at 7 till probably 11:00. i will check back at 11 and leave you a message. I will be back in my office at 7:30 AM for an hour and will try to reconnect then. Hopefully I have explained what is happening.



It's ok I will wait until you get back. In the meantime here is the solution


The issue is that the SUMIF formula in cell K1299 sums values in K when the corresponding value in C is equal to C9


C9 has the value of '2012 (with the apostrophe)


Since the value in C169 which corresponds to cell K169 IS NOT EQUAL TO THE VALUE IN C9, cell K169 will not be included in the SUMIF formula in K1299


To see what I mean type '2012 in cell C169 (which is the same value in C9) and you will see that cell K1299 will add the value in K169


I can send you the corrected file if you like


Hope this helps. Thank you for rating this answer "Excellent" or "Good" if I was able to answer your question


I hope I was able to explain the problem clearly. If not let me know



John D and 4 other Microsoft Office Specialists are ready to help you

John, if you do not need further help please click the rating button so I get paid for my time on this long thread



Customer: replied 4 years ago.



thank you. Once you demonstrated what it was, it was very understandable. I put the YTD in on the chart so it would show up on the graphs not thinking of the downstream impact.



Thanks. Glad I could help