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 colu...
SnowMan55
May 15, 2023Bronze 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).