Results based on subdata
I know this title isn't exactly very descriptive but, it was the best I could come up with.
I would like to calculate a percentage for the whole based on the result of its parts. Each sample I have has a varying number of sub samples. Now i could do this all by hand but, with around a thousand samples that would be just slightly tedious. Below is a piece of sample data to look at.
In that case I want to know the percentage of positive results for sample 0701950 and also 0701951. Positive results are anything with a result of "P", "R", "S", or not having an "-". I figured a SumProduct forumla would do it but becuase of the sub sample numbering that proved a mightly challenge for me. I tried to use the "*" wildcard but excel doesn't seem to recognize it or I used it incorrectly. I'd like to be able to just click/drag the formula so it auto fills for all my samples without having to adjust it for each new set as well. I'm hoping one of you here are much more cleaver then I when it comes to this .
Thanks in advance for any help you can offer.
Valued Forum Contributor
a helper column with left(a1,7) is a choice for you
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1