Dear all,

I need your help to find out a function to move across tabs in Excel.

In the file attached, each tab corresponds to a country. Every country need to select with 1 the name they like the most for the colour red.

In the tab dashboard, I'd like to insert a SUMIF function in order to sum up all the values and to pick the one that has been selected the most. I was thinking about an indirect, but no clue how to deploy it.

Could you please support?

test.xlsx