HELP! LOOKUP / IF / SUM expression

[dididramis]

Hi,

I'm having a hard time figuring out the expression I need to use to get the values I need.. Can somebody help?

Here's an exemple of what I'm trying to achieve...

In Table 2, I want to populate the [VISITORS (TOTAL)] virtual column with values found in Table 1.

The expression needs to match both YEAR and CITY values and give me the total of visitors for each city per year. YEAR and CITY entries in Table 2 will be done via a simple form.

Is there a way to do that?

Thanks!

[Joseph_Seddik]

Use SUM() with SELECT(). Use AND() in SELECT()’s condition to match both the city and year.