Modify formula

[Blake0920]

Trying to modify an existing formula where I can segregate different options within the same column and have them return a percentage depending which value was chosen.

The current formula is set up to calculate whether "S" has been selected. I need to add "R", "E", and "O"

This is the current formula. =SUMPRODUCT(SUBTOTAL(3,OFFSET(D4,ROW(D4:D48)-ROW(D4),0,1,1))*ISNUMBER(SEARCH(", "&TRANSPOSE(D7)&",",", "&D4:D48&",")))/SUMPRODUCT(SUBTOTAL(3,OFFSET(D4,ROW(D4:D48)-ROW(D4),0,1,1))*(LEN(D4:D48)-LEN(SUBSTITUTE(D4:D48,",",""))+(D4:D48<>"")))

Thank you.

 

[Fluff]

Duplicate to: Separating values

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.