Hi all,
I am trying to sum the products of certain ranges, but only for certain attributes. The formula is supposed to sum the products of price and units, but only for the colour e.g. "blue", or "green". Though sometimes, depending on what attribute is selected in my comboBox, it should sum the products of ALL colours. In non array formulas, a simple "*" works to include all of them, unfortunately it doesn't seem to work in an array. Is there a different way to write it?
works!Please Login or Register to view this content.
Does not work!Please Login or Register to view this content.
Bookmarks