May 15 2023 07:09 AM
Hi!
I need to sum multiple rows in a spreadsheet to make a summary amount based on a matching term in one of the columns. I've created the Vlookup to find the matching term and identified the column that it needs to add but I'm not sure what to add to tell it to find multiple instances in the source table and add them - currently it's just giving me the first value.
I have attached a file with a snapshot of the data, I need to add up the "Total Score" column of all rows which have the same City, in another page which has the cities listed.
TIA
May 15 2023 07:27 AM
Rather than a VLOOKUP function (which matches one row), look into the SUMIF function (or if multiple matching criteria are needed, the SUMIFS function).