Frustrated

Closed
kd - Nov 4, 2009 at 07:27 AM
aprpillai Posts 4 Registration date Wednesday November 4, 2009 Status Member Last seen November 5, 2009 - Nov 5, 2009 at 02:15 AM
Hello,
I am trying to add up the diameters of a series of stems on a group of trees. here's how i'm getting the data from our data logger:
Plot Plant Stem No. Diameter
1 1 1 5
1 1 2 5
1 1 3 2
1 2 1 4
1 2 2 5
2 1 1 10
2 1 2 1
2 1 3 5
2 1 4 4

etc. there are a variable number of stems per plant, so i've been trying to figure out how i can "tell" excel to sum a series of cells until it reaches the end of that plant, then go on to the next plant eventually ending with:
Plot Plant DiaSum
1 1 15
1 2 10
etc.

I feel this should be easy, but I can't seem to figure it out. If anyone can point me in the right direction, i would appreciate it.

1 reply

aprpillai Posts 4 Registration date Wednesday November 4, 2009 Status Member Last seen November 5, 2009
Nov 5, 2009 at 02:15 AM
Hi,

A quick thought ; Try the Data - ->Subtotal method and take a subtotal on Plant Column and sum-up the Diameter Column value.
0