the first formula gave me a div/0 error. The second one almost works. When i copy it down to calculate the 5 categories in 5 different cells at the bottom, the formula seems to work fine except for one cell where, instead of calculating the correct value of 0.0765, it comes up with a value of 5.53. Bizarre. I double-checked the references and everything looks fine. it's just that cell that calculates oddly.