Some sort of sum product

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

azidrane - 31 May 2006 17:42 GMT

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?

Reply to this Message

Bob Phillips - 31 May 2006 17:51 GMT

=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.

Signature

HTH

Bob Phillips

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

> I have a series of names in a coulmn in Sheet1. I have a range of data
> in sheet2 that looks like this.
[quoted text clipped - 13 lines]
>
> Any tips?

Reply to this Message

azidrane - 31 May 2006 18:39 GMT

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!

> =SUMIF(Sheet2!A:A,A1,Sheet2!B:B)+SUMIF(Sheet2!A:A,A1,Sheet2!C:C)
>
[quoted text clipped - 24 lines]
> >
> > Any tips?

Reply to this Message

Bob Phillips - 31 May 2006 23:40 GMT

What a team! <g>

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> 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
[quoted text clipped - 34 lines]
> > >
> > > Any tips?

Reply to this Message