Obtaining all values in a specific column with a fixed lookup (text) value [Solved]

Hi everyone,   I'm trying to figure out a smarter and more convenient way to sum multiple cells with a fixed lookup value in an extensive sheet. Using a vlookup, or an index-match gives the first v...