Struggling With How to Create A Formula for Desired Result...

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!

To add to oldchippy's post, if you want to count the number of 3 different codes in one cell, you could use:

Please Login or Register  to view this content.

HTH

Jason

Jason and Old Chippy,

Not quite a total count. I am more interested in how many times a C1F2S1 appears, how many times a C3F3S1 appears, etc. So whatever HHRG codes I specified, the formula would determine "Okay, there are 208 of X, 535 of Y, and 98 of Z, out of the total 3900. All together, thats (208+535+98) 841. Now I'll do 841 x 2325 (or whatever value I chose), which will give me 1,955,325." All of this into a single cell. Possible?

Thanks for the help so far.

I think the formula I posted will almost do what you are asking (other than the multiplication). To incorporate this, just use:

Please Login or Register  to view this content.

Jason

Old Chippy,

I'm in the health care field, and HHRG codes are just fancy "codes" that Medicare uses to assess the level of care a patient may need. HHRG codes are the C1F3S2's, C3F3S4's, etc. Sorry if I just threw that term out there by accident. I am not currently in my office today with access to the shared drive that my worksheet is stored on, but tomorrow I will give those a try and report back to you guys.

Thanks for the help jason and old chippy.