Care to provide a small sample along with the expected outcome?

Shi Gharib wrote:
Hi
in a table I have several columns that contains in the first row a part of
the same name ex: "BRV"
I want to sum several separated rows that have the same above condition.
is there a way in the sumif function or is there a way to use the sumproduct
function that allows me to have one condition and multiple values to
calculate