Forum Discussion
CharlotteHawkes
May 15, 2023Copper Contributor
Help Adding Together Values in Multiple Rows that meet Vlookup search
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
1 Reply
- SnowMan55Bronze Contributor
Rather than a VLOOKUP function (which matches one row), look into the SUMIF function (or if multiple matching criteria are needed, the SUMIFS function).