View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Sumproduct Question

Sounds like rounding in some cases and not in others. What are the formulae?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
All,

I am using sumproduct to calculate percentages on 3 different levels.
One is a divisional level another Regional and last district....An
example is 83.5% for divisional, 77.3% region 1, 83.2% region 2, 90.8%
region 3. When I average the three regions together I do not arrive at
83.5%; I have 83.8%. This occurs between the district and regional
levels also, and I am perplexed!

All of my counts are correct on each level and I am utilizing the same
exact calculations at each level. Why will the averages be
different???? Anyone have a clue?

Thanks,

Hans