Spreadsheet: 135716d1326205853-formula-countif-multiple-ranges-with-one-criteria-test-worksheet
Sheet: Sheet1

Original Payment |  |  | FI/MAC Appeal Determination |  |  | QIC Appeal Determination |  |  | ALJ Appeal Determination |  |  | ACR Appeal Determination |  |  | US District Court Determination
7640.7
31710.74
31651.26
6583.36
5995.24
7592.99
6524.99
7592.99
11873.48
6605.72 |  |  | Overturned_in_Provider_Favor
7607.36
8865.15
6583.36
6591.06
7607.36 |  |  | Upheld |  |  | Upheld |  |  | Pending
6591.85
7592.99
5572.85
6049.76
6591.06
3467.53
13528.36
14794.74
9007.88
9832.52
8893.15
6653.57
13374.81
11752.1
17372.11 |  |  | Overturned_in_Provider_Favor
11507.19 |  |  | Pending
8066.12
11864.33
18469.7 |  |  | Overturned_in_Provider_Favor
16533.5
16543.69
16792.72 |  |  | Overturned_in_Provider_Favor
24420.8
16839.74 |  |  | Upheld |  |  | Upheld |  |  | Pending
10443.07
16501.55
15664.53
11562.06
35328.12
5095.16
25754.18
16895.04 |  |  | Upheld |  |  | Upheld |  |  | Pending
27788.08
28780.08
11107.27
12131.27 |  |  | Overturned_in_Provider_Favor
11811.66
18099.4
30771.27
30122.11
31629.46
9895.02
11069.58
8829.7
9171.15
6902.33
21920.49
7596.41
5276.97
8552.12
7484.12
7528.12
10676.69
21981.5
8861.66
10349
7125.08
4970.31
9578.69
8581.54
6023.78
5963.07
6987.07
8986.85
6987.07
8596.11
9620.11
5963.07
8509.6
9501.6
5407.81
5417.56
8518.69
8320.92
14939.78
8946.71
8946.71
12293.73
9759.14
13435.76
18273.44
3006.94
6617.18
4080.82
5111.71
4087.71
7609.18
4105.43
5647.16 |  |  | Upheld |  |  | Upheld |  |  | Pending
3520.86
3633.13
7983.88
5269.74
4089.76
5119.47
4095.47
4095.47
4095.47
5119.47
4261.45
6330.48
3499.28 |  |  | Upheld |  |  | Upheld |  |  | Pending
3576.48
3543.28
3514.27
4418.49
4600.48 |  |  | Pending
2972.39 |  |  | Upheld |  |  | Upheld |  |  | Pending
2777.56 |  |  | Upheld |  |  | Upheld |  |  | Pending
4198.66 |  |  | Overturned_in_Provider_Favor
4182.46
6471.53 |  |  | Overturned_in_Provider_Favor
3845.56
5266.66
2976.85
5403.53 |  |  | Overturned_in_Provider_Favor
3615.64 |  |  | Overturned_in_Provider_Favor
4597.24 |  |  | Upheld |  |  | Upheld |  |  | Pending
4565.24
3514.27
4558.75
4633.07 |  |  | Pending
4450.24
3365
3614.24
3526.74 |  |  | Upheld |  |  | Upheld |  |  | Pending
3321
4140.02 |  |  | Overturned_in_Provider_Favor
3910.78 |  |  | Overturned_in_Provider_Favor
5204.42 |  |  | Pending
2657.79
3810.74 |  |  | Upheld |  |  | Upheld |  |  | Pending
5113.76 |  |  | Upheld |  |  | Upheld |  |  | Pending
6024.15 |  |  | Pending
9030.92
3810.74 |  |  | Upheld |  |  | Upheld |  |  | Pending
4169.83 |  |  | Upheld |  |  | Upheld |  |  | Pending
4423.13 |  |  | Upheld |  |  | Upheld |  |  | Pending
3826.77
4251.48 |  |  | Upheld |  |  | Upheld |  |  | Pending
4145.36 |  |  | Upheld |  |  | Upheld |  |  | Pending
1841.85 |  |  | Upheld |  |  | Upheld |  |  | Pending
5298.09
4145.36 |  |  | Upheld |  |  | Upheld |  |  | Pending
5331.22
3302.5 |  |  | Upheld |  |  | Upheld |  |  | Pending
3967.65
5014.43 |  |  | Upheld |  |  | Upheld |  |  | Pending
15335.8 |  |  | Pending
4971.9 |  |  | Pending
6026.61
5757.48
8986.83
8508.05
8508.05
5410.38
9532.05
9532.05
8508.05
15864.81
13520.1
20575.26 |  |  | Pending
24821.04
32803.72
26627.39
15780.17
10979.01
11699.68
8931.31
5639.26
9642.3
5818.2
5818.2
6045.77
4943.12
5185.61
5005.13
6029.13
6465.74 |  |  | Pending
9501.91
10363.04
18332.86
8398.2
11940.87
14086.97 |  |  | Pending
14081.38
8385.15
9453.15
6916.38
14114.62
8385.15
11878.66
15105.38
3189.97
5800.74
3770.53 |  |  | Pending
3770.53
4420.6 |  |  | Pending
5288.72 |  |  | Pending
5449.38
1805.6
3506.59 |  |  | Pending
4112.93
11118.62
9828.04
9421.76
7323.57
11821.39
15082.39
8955.91
24673.73
10023.91
14580.96 |  |  | Pending
23784.56
18320.9
7633.57
6609.57
6095.63
5518.41
5424.79
6492.79
3615.64
4791.49
4182.7 |  |  | Pending
3337.64
7344.99
7366.4
4987.88
6914.32
6011.88
6299.74
4198.66
5424.79
9875.97
5231.74
3988.13
4198.66
3337.64
3988.13
5424.79
10791.98
17747.67
8114.3
8420.66
17585.53
11754.82 |  |  | Pending
6907.87
12723.68
21535.93
13438.72
10048.17
15358.54
2507.66
6500.13
3224.95 |  |  | Pending
4229.93
4947
6120.5
2909.77
4410.36 |  |  | Pending
5112.94
7535.83
11287.39
7344.48
13040.88
4834.52
5266.66
6471.53
8385.45
4198.66
5424.79
4181.43
7344.99
5424.79
5403.53
6471.53
5211.13
7361.45
4181.43
6279.13
5403.53
4815.21
6471.53
5447.53
5231.74
5211.13
5447.53
5403.53
5249.43
5048.54
6471.53
10672.51
10195.33
9156.29
8552.43
18661.64
9620.43
14281.77
9919.77
16636.66
11712.85
3640.16 |  |  | Pending
7054.45
9518.57 |  |  | Pending
10388.02
3422.03
3600.78
2754.57
8891.99
8993.41 |  |  | Pending
4709.84 |  |  | Pending
5112.94 |  |  | Pending
4038.51
6007.31
6016.11
11460.43 |  |  | Pending
15012.29
5614.67
3706.35
15453.86
6016.12
6062.89
4977.5
5566.6
5661.83
3466.03
5617.83
6590.6
6326.09
11070.33
11492.8
3854.74
6250.69
3854.74
7274.69
4114.42
4068.52
4114.42
3854.74
9699.08
11855.67
11677.94
12920.54
3252.45
4370.05
10628.51
17771.9
7486.7
14883.26
2820.57
3156.9
8898.36
12116.91
4289.78
30582.74
33938.74
10982.26
12930.32
4289.78
6181.29
13055.67
3740.31
2716.31
3255.6
3419.82
6479.89
3598.66
3543.28
2395.82
3622.42
8175.53
2736.26
3808.52
2175.73
9975.67
13484.8
3844.46