Assume your data in A1:B11
Criteria in D2 holds Beefsteak, D3 holds Big Boy....

In E2: =SUMPRODUCT(--($A$2:$B$11=D2),$A$1:$B$10)
copy down


"crispino" wrote:

Hi all,

I am trying to keep track of various types of tomato seedlings on growing
trays. Each tray is divided into eight sections and each section will have a
certain number of seedlings in it. However the data are not contiguous, but
instead are laid out in such a way so as to approximate everything's position
in the tray. The data are always arranged with the number above and the type
in the row below. A typical example might look something like this:

4 3
Big Boy Early Girl

4 4
Roma Big Boy

2 3
Early Girl Beefsteak

4 4
Big Boy Roma

My questions is, is there a way to do a dynamic sum of each type? So, in
the example above, there would ultimately be a list that looks like:
3 Beefsteak
12 Big Boy
5 Early Girl
8 Roma

The fact that the data types are not separated into discrete columns and
rows have hampered my efforts to figure this out so far. How would I do this?

Any help would be greatly appreciated. I'm using Excel 2003.

- Chris