• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Running total for each day up to a month then start over?

    Hi, I am working on a report that needs to maintain a running total of rail cars shipped each day only for the month then start over. I have attached an example report. On all 5 tabs, MON-FRI in cell S19 is where these running total needs to appear based on C19 of every sheet. I have tried...
  2. K

    Totaling data on one sheet from another based on a weeks worth of numbers.

    Please see attached. Sheet 3 is a tally sheet. Showing the total for a single customer over a week period. The number needs to be represented by the ship day from June 2016. Daily Entry is just an data entry form but ties to June 2016 by a formula to count as well. What I am trying to do...
  3. K

    Totaling data on one sheet from another based on a weeks worth of numbers.

    Please see attached. Sheet 3 is a tally sheet. Showing the total for a single customer over a week period. The number needs to be represented by the ship day from June 2016. Daily Entry is just an data entry form but ties to June 2016 by a formula to count as well. What I am trying to do...
  4. K

    Add cells together on one page and putting total in another!

    Hi Narayank991, So it turns out I was thinking about a certain situation. I am hoping you can help me one more time. What I forgot was that my weeks are not as straight forward as I had requested. Could you take a look and see if you can help. So what is going on is... if you take a look at my...
  5. K

    Add cells together on one page and putting total in another!

    Yes, I that is exactly what I needed it to do. I just couldn't get my formula to total. Thank you so much.
  6. K

    Add cells together on one page and putting total in another!

    Hi there, What I need help with on this attachment is taking data from AA:AE on Sheet 1 and putting it in Sheet 2. This is based on the exact customer name. So week 1 totals on Sheet 2 would include all "Foundation Building Materials - Escondido, CA". And so on for each customer. My biggest...
  7. K

    Need Help..."it just doesn't add up"!

    Thanks again. I have the formula working for those lower cells. I truly appreciate all your help. I have to run a full test on my report. I will let you know how that goes. :)
  8. K

    Need Help..."it just doesn't add up"!

    Yes I did copy. However, what I didn't do was change the number in the formula you gave me when I had to jump a row or several rows. Everything is taking shape. Do you mind helping me one more time? If you look at the bottom of June 2016 you will see a place with total areas. These formulas used...
  9. K

    Need Help..."it just doesn't add up"!

    That did not work either. Where there is no number in cell c2 on June 2016; there should be no number in that column for any customer. When I entered your formula I got the number "2" in column c for three different customers. This is when I stopped and decided to reply to you. Would you like to...
  10. K

    Need Help..."it just doesn't add up"!

    IT did not work. It populated other customers with a 2 who were not marked on sheet 2. Please see my new upload. It is what I am working on exactly.
  11. K

    Need Help..."it just doesn't add up"!

    Please see my new attachment. It is exactly what I am working on. Be sure to read what I am trying to accomplish in my last post with attachment.
  12. K

    Need Help..."it just doesn't add up"!

    Good morning, it appears to not work exactly as I thought. I am going to try and explain it a little differently. On Sheet 1 in my upload is where my formula will need to go. My current formula that I have is posted in this thread. What I need it to do is: lookup the customer name from sheet 1...
  13. K

    Need Help..."it just doesn't add up"!

    I think that is the ticket! Thank you for now...I will let you know the outcome as soon as I finish up the copying of formula and run a test. p45cal
  14. K

    Need Help..."it just doesn't add up"!

    Thanks. My file was too large. I pasted the main report on sheet 1 and a portion of my Sheet1! onto sheet 2 of this file. Hope this helps.
  15. K

    Need Help..."it just doesn't add up"!

    =IF(ISBLANK($A$66:$A$543),"",(IF(ISBLANK(E$2),"",(VLOOKUP($A$66:$A$543,Sheet1!$A$4:$AA$397,HLOOKUP($B$2:$AI$2,Sheet1!$B$1:$Z$2,2,FALSE),FALSE))))) Above is my formula. This formula is on my report page. My sheet1! is where we enter the data needed for the report. The only thing that seems to be...
Back
Top