This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to aggregate data that is stored diagonally but having hard time to get it done. As an example, in the attached file, all the cells that are blue in color should be aggregated and return the value in cell B13. Similar for all the other colors.