Summing only some rows of a matrix based on condition

  • Hi All,

    nice to meet you, my first post here. I'd like to have your opinion:

    Problem: I've one matrix of data and a tag for every row

    [Blocked Image:]

    The ranges are named Tags and Data. I need to get the total of "data" for the values in rows which have a selected value in Tags.

    I've come up with this to sum for example, tag "a"

    (array formula)


    It works but is basically not understood by most endusers, do you see other options to do this in a more "friendly" way?

    Thanks in advance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!