Hi,

I have a wkst that has a long list (3900 rows) of values in column U. The values are representative of a Medicare HHRG scoring function, and are all very similar (ex: they're like C1F1S1, C1F3S2, C2F1S1, etc.) and are recurring throughout the column. If I want to create a formula that performs a function that will take all specified values (say I just want all the C1F2S3's, C3F2S2's, and C2F3S5's), then take the combined amount (ex: there are 800 of them all total), and then takes the amount and multiplies it by a value....how would I do so? This may be confusing, and I understand, but any help is greatly appreciated.

Also, if you are confused, ask me to explain myself further and I would be more than happy to do so.

Thanks!