Prev: work book open _ event
Next: Moving The Decimal Point Of Existing Entries
From: Analyst in the making Analyst in the on 3 Jul 2008 06:11
I need to take column B (customer account number) and state if the value is x
then take the monetary value in column P and add up the total value of all
entries for this customer.
Then I want to place the answer on a different worksheet in the same work
book.

Please can someone help me?

From: Pete_UK on 3 Jul 2008 06:49
Something like this in a cell in Sheet2:

=SUMIF(Sheet1!B:B,"x",Sheet1!P:P)

Hope this helps.

Pete

On Jul 3, 11:11 am, Analyst in the making <Analyst in the
mak...(a)discussions.microsoft.com> wrote:
> I need to take column B (customer account number) and state if the value is x
> then take the monetary value in column P and add up the total value of all
> entries for this customer.
> Then I want to place the answer on a different worksheet in the same work
> book.
>
> Please can someone help me?

From: Analyst in the making on 3 Jul 2008 07:12
Brilliant, thank you, but I need to do 9999 and I can't seem to drag the
formula down the page

"Pete_UK" wrote:

> Something like this in a cell in Sheet2:
>
> =SUMIF(Sheet1!B:B,"x",Sheet1!P:P)
>
> Hope this helps.
>
> Pete
>
> On Jul 3, 11:11 am, Analyst in the making <Analyst in the
> mak...(a)discussions.microsoft.com> wrote:
> > I need to take column B (customer account number) and state if the value is x
> > then take the monetary value in column P and add up the total value of all
> > entries for this customer.
> > Then I want to place the answer on a different worksheet in the same work
> > book.
> >
> > Please can someone help me?
>
>
From: Pete_UK on 3 Jul 2008 07:46
Put your account codes say in Column A of Sheet2, starting with A2,
and then change the formula to this:

=SUMIF(Sheet1!B:B,A2,Sheet1!P:P)

and then copy it down.

Hope this helps.

Pete

On Jul 3, 12:12 pm, Analyst in the making
<Analystinthemak...(a)discussions.microsoft.com> wrote:
> Brilliant, thank you, but I need to do 9999 and I can't seem to drag the
> formula down the page
>
>
>
> "Pete_UK" wrote:
> > Something like this in a cell in Sheet2:
>
> > =SUMIF(Sheet1!B:B,"x",Sheet1!P:P)
>
> > Hope this helps.
>
> > Pete
>
> > On Jul 3, 11:11 am, Analyst in the making <Analyst in the
> > mak...(a)discussions.microsoft.com> wrote:
> > > I need to take column B (customer account number) and state if the value is x
> > > then take the monetary value in column P and add up the total value of all
> > > entries for this customer.
> > > Then I want to place the answer on a different worksheet in the same work
> > > book.
>
> > > Please can someone help me?- Hide quoted text -
>
> - Show quoted text -

 | 
Pages: 1
Prev: work book open _ event
Next: Moving The Decimal Point Of Existing Entries