Compare daily and MTD totals to see if they add up

[seanmh72]

Hello all,
I am trying to look at some data that we are getting from a database. This database has a lot of data, but what we are concerned with is a daily number and a month to day (MTD) total. For instance, we have a daily total that shows how many people enrolled and that is then summed to the MTD total. The first instance of this would be for customer on row 8 column H (H8) for their daily enrollment on January 1. Their MTD for Jan 1 would be on L8. Their next would be for the daily on P8 and then the MTD would be on Q8. This is systemic through out the worksheet. I know exactly where to look for the data for each customer.

Now, what I really need to do, is to look at the MTD total for January 1, add the daily from January 2 and see if it matches the MTD total for January 2.

Essentially, does H8+P8=Q8, etc., etc., for each day of the month. If it does, great.....if it doesn't, put something on screen to tell me that there is a problem.

I have some programming experience and excel experience, but I am just not getting anywhere with this.

Any help is appreciated.

Thanks!!!!

[jmac1947]

Hello and welcome to the forums

It is always a really good practice to post a sample workbook with your input data and your expected results (in this case an example of OK and an example of an error). To post a workbook use the "Go Advanced" link at the lower right hand side of the posting window.

Having an actual workbook helps us to get a much clearer picture of your request than many lines of text where it is very easy to get the wrong message.

You will find the forum contributors very very knowledgable (after a number of years I am still learning from almost every thread) volunteers. Any thing you can do to make it easier to help you will increase your chances of a speedy response

again, welcome to the forums, look forward to seeing your sample workbook

Jmac1947

[seanmh72]

Sorry, I guess an example would make it much easier.....

If you look at the highlighted row, you see that there is a Daily Enrollment v3.0 and a Daily MTD v3.0 column. These should make 'sense' when you add them up from day to day. Sometimes, as you see highlighted in red, don't add up correctly.

This is just an example, but it is essentially what I am trying to accomplish.

Thanks!
Sean

[jmac1947]

Hi Sean,

thanks for the example, I now see what you are doing and understand what I thought was a typo in your original post wasn't

first question, how many instances of the data do I expect to be on a single row??

jmac

[seanmh72]

jmac,
Well, there could be 'infinite'....meaning we are going to be looking at months of data....as you can see, the columns are for each day of the month and I am not sure where in any month there could be an issue. I need to run this against a lot of data points.

If it does help though, I can do this for a specific period, but run this multiple times.

Hope this helps your question.

Sean