Formulas

[Cspen]

What formula do I need in order to find the totals for each variable set. This example was pulled from an old workflow and I am trying to replicate it. Thanks in Advance

. 

[Qiu]

@Cspen 
Can you provide more details?

[Raj]

@Cspen 
please add some sample input and expected output
will be in better place to help.

[Cspen]

Here is a very simple example. I have a large data set so my calculations won't be just one but for an example I am looking at the "initial HRA" and "current HRA" to try and calculate how many went  from Low-High, Low-Medium, Low-Low. Medium-High, Medium-Low, Medium-Medium Etc. So looking at the initial HRA if its low and then changed to high in the Current HRA. That is what I am trying to calculate.

[Cspen]

@Raj   The example is above 

@Qiu 

[binuacs]

@Cspen can you also upload the example excel files?

[Raj]

@Cspen 
input files are missing.

[Cspen]

@binuacs @Raj  Here are the sample input files

[binuacs · Accepted solution]

@Cspen like this?

[Cspen]

@binuacs  YES!! Thank you. I was able to figure it out using the IF THEN formula but this is way easier!

Thank you!