Checking column for values and returning a running total.

Hello all,

This is my first post on this forum! I just got into Excel again and I'm glad there's a community here to help out. I encountered a problem while sifting through some work earlier and have attached an example of it.

I have a column of dates and points on Table 1. I need to report the percentage of points so far accrued on or before the date listed in Table 2.

I tried using an IF statement to go through the list of dates in Table 1 and check if they are lesser than or equal to the date listed in Table 2. If the dates are equal or lower, the statement should pull the corresponding value from the Points column.

Using the Evaluate Formula command in Excel, the formula works through the true/false check but falls flat after that.

Any advice would be appreciated!

Perfect! It did exactly what I wanted.

Thank you!