Help from excel wiz please ...

[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

[bmxbandit]

i'd say to use sumif() to create a table of sums (then use vlookup() to look up these sums from another document, if thats what you need). i'm in a bit of a hurry but ill answer more fully later if nobody else has!

[gazzae]

As bmxbandit says use SUMIF.

Say if the critera is in column A rows 1-6 and the data is in column B rows1-6 then the sumif to total all the X's would be this....

=SUMIF(A1:A6,"X",B1:B6)

[bmxbandit]

for x:

=sumif(A1:A6,"X",B1:B6)

others likewise

[markmarkymark]

thanks All !!

mark