View Single Post
  #4   Report Post  
Old May 6th 19, 06:10 AM
yaj yaj is offline
Junior Member
 
First recorded activity by ExcelBanter: May 2019
Posts: 1
Cool using ranges to determine aggregate areas

I can get the areas of individual diameters, but I need to get the total for a range of diameters. If I have 10 different measurements of tree limbs, I need the total area of the 10 limbs. Right now, I have to calculate each one separately and then add them up.

=(3.14*(C2/2)^2)+(3.14*(D2/2)^2)+(3.14*(E2/2)^2)+(3.14*(F2/2)^2)+(3.14*(G2/2)^2)+(3.14*(H2/2)^2)+(3.14*(I2/2)^2)+(3.14*(J2/2)^2)+(3.14*(K2/2)^2)+(3.14*(L2/2)^2)+(3.14*(M2/2)^2)

There otta be a better way ... and I broke me head trying to find it. Not a math whiz, but competent with simple formulas. This is a practical exercise for a horticulturalist who consults on trees all the time.