Hello,

I have a row (4) of factors (e.g. "Taller than 5'6", "older than 25", etc) and a row (7) of corresponding values (e.g. 40, 6, 0, 0, 8) which is populated if the particular person meets that criteria, so that a score can be produced. Once the score has been summed up, I want to have a string of text that takes only the values from row (4) where there is a value in row (7) that is greater than 0. That way, I can see which factors are contributing to the score (there are about 200 factors).

I tried something like this:

=concatenate(if(G4:P4>0,G7:P7))

but it didn't work. I've done something similar with the sum function and it worked, but I'm trying to do the same thing with concatenate. Any help would be greatly appreciated.