Some sort of sum product

[azidrane]

I have a series of names in a coulmn in Sheet1. I have a range of data
in sheet2 that looks like this.

Name1 DataType1 DataType2
Name2 DataType1 DataType2
Name3 DataType1 DataType2
Name1 DataType1 DataType2
Name3 DataType1 DataType2
Name2 DataType1 DataType2
Name1 DataType1 DataType2


I need to add up coulmn B in Sheet2 and coulmn C in Sheet2 and divide B
for each name in Sheet1. There are multipule instances of a name in
sheet2 coulmn A and I need to add each instance in coulmn B and coulmn
C before dividing.

Any tips?

 

[Bob Phillips]

=SUMIF(Sheet2!A:A,A1,Sheet2!B:B)+SUMIF(Sheet2!A:A,A1,Sheet2!C:C)

not sure what divide B means but perhaps you could add that bit.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[azidrane]

Almost. That is nearly what I had done before. What I had done before
was close to correct, and the fact that you sort of thought on the same
lines I figured i'd revisit the proposed solution. What I wanted was
this
"=SUMIF(Sheet2!A:A,A1,Sheet2!B:B)/SUMIF(Sheet2!A:A,A1,Sheet2!C:C)". But
the problem was my own formatting. I figured it out. Thanks for your
help.

Cheers!

 

[Bob Phillips]

What a team! <g>

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)