dbwiz
Active Member
- Joined
- Nov 20, 2007
- Messages
- 275
Problem: Row 34 contains sums of all average employees. These averages are correct. Row 36 contains sums of all eligible employees. If all employees are eligible (as in this example, the numbers in BO36 BP36, BQ36 should be the same as BO34 BP34 and BQ34. However they are not. Am wondering if it is a rounding issue with the SUMPRODUCT formula. (same one exists for whole row, and numbers tie on BR, BS, BT, etc. However they are not. Is there a different formula I could use here? Here is a sample:
City of R Community Dev - Exec & Mgmt 85% (2) 03-10-09 CH.xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
BO | BP | BQ | BR | BS | BT | BU | BV | BW | |||
24 | 545.86 | 634.21 | 662.50 | 2,269.80 | 1,936.15 | 1,699.01 | $28,864.37 | Yes | |||
25 | 244.61 | 284.20 | 296.88 | 1,017.14 | 867.63 | 761.36 | $12,934.69 | Yes | |||
26 | 191.13 | 213.03 | 222.54 | 688.75 | 587.51 | 515.55 | $8,758.67 | Yes | |||
27 | 308.58 | 363.24 | 378.72 | 1,337.46 | 1,140.86 | 1,001.13 | $17,008.16 | Yes | |||
28 | 316.41 | 372.45 | 388.32 | 1,371.39 | 1,169.80 | 1,026.52 | $17,439.55 | Yes | |||
29 | |||||||||||
30 | |||||||||||
31 | |||||||||||
32 | |||||||||||
33 | |||||||||||
34 | 321.51 | 373.55 | 390.21 | 1,336.91 | 1,140.39 | 1,000.72 | 17,001.09 | ||||
35 | AFA | ||||||||||
36 | 321.32 | 373.43 | 389.79 | 1,336.91 | 1,140.39 | 1,000.72 | 17,001.09 | #REF! | |||
Benefit Data |