[markmarkymark]

Greetings ....

Suppose I have a column A that has the following data:

X
Y
Y
Z
X
X

Suppose I also haev column D which has the following data (opposite the data above)

10
20
22
50
15
12

How do I use lookup (I have tried I promise!!) to sum that totals of A, B and C in the following format:

Total X Total Y Total Z
37 42 50

Obviously I need to do three sums which look up Column A and only add the content of Column D if a particular row as the criteria I am looking for (i.e. X values, Y values or Z values .......

thanks to the wiz that can help me out here!!
cheers

Mark