Does anyone have any suggestions on how to match the values within tables?
For example, there are 2 tables
Table 1 contains date, which is from cell A595 to H604
Table 2 contains value, which is from cell A607 to H616

The date in cell A595 will refer to the value in cell A607.
....
The date in cell H604 will refer to the value in cell H616.

If any cell within table 1 equals to today, then sum up all the referred
cells value within table 2, and return into cell A618.

If cell A595 equals to today, then refer to the value 5 in cell A607.
If cell H607 equals to today, then refer to the value 15 in cell H616.

then the sum of the values is 20, which should return into cell A618

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric

In cell A618:

=SUMIF(A595:H604,TODAY(),A607:H616)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric" wrote:

Does anyone have any suggestions on how to match the values within tables?
For example, there are 2 tables
Table 1 contains date, which is from cell A595 to H604
Table 2 contains value, which is from cell A607 to H616

The date in cell A595 will refer to the value in cell A607.
...
The date in cell H604 will refer to the value in cell H616.

If any cell within table 1 equals to today, then sum up all the referred
cells value within table 2, and return into cell A618.

If cell A595 equals to today, then refer to the value 5 in cell A607.
If cell H607 equals to today, then refer to the value 15 in cell H616.

then the sum of the values is 20, which should return into cell A618

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric