Sum of values in a column in excel that are all related to the same single value present in another column

yes, we can treat it like a local variable name

For LINQ also have a look here: