Martin B.
01-17-2011, 06:32 AM
[Great genius people of the VBA express forum. :bow:
I am currently working on a SUMPRODUCT formula. For one of the criteria’s I want it to grab the value from another cell. And in this sell I want to add up several criteria’s. For example cell value: "1, 2, 3, 4". This would mean that it would look for values 1, 2, 3 and 4.
I also want to have multiple values in the cell that refers to values that start with a certain value. For example cell value: 093%, 094%, 095%. This would mean that it would look for values that start with 093, 094 and 095.
Does anyone have a resolution for this?
Many thanks,
Martin
I am currently working on a SUMPRODUCT formula. For one of the criteria’s I want it to grab the value from another cell. And in this sell I want to add up several criteria’s. For example cell value: "1, 2, 3, 4". This would mean that it would look for values 1, 2, 3 and 4.
I also want to have multiple values in the cell that refers to values that start with a certain value. For example cell value: 093%, 094%, 095%. This would mean that it would look for values that start with 093, 094 and 095.
Does anyone have a resolution for this?
Many thanks,
Martin