Hello, I am trying to get a total after searching multiple columns and rows in a table. The columns are the categories and the rows are the different and unique data.
What method would be most effective to scan down a row for a unique identifier then move on to the next column to search for another unique identifier until it gets to the end and sums the total for everything that matches? It would only have to scan about 3 columns out of a total of 10. So I would input the 3 different identifiers and hopefully get excel to give me the sum of all the rows that match them.
What method would be most effective to scan down a row for a unique identifier then move on to the next column to search for another unique identifier until it gets to the end and sums the total for everything that matches? It would only have to scan about 3 columns out of a total of 10. So I would input the 3 different identifiers and hopefully get excel to give me the sum of all the rows that match them.
