I want to add the sales (column B) of the people in column A.

A B
James 23
Randy 43
Paul 12
James 40
Paul 50

....and get this result:
C D
James 63
Randy 43
Paul 62

Only the result in column D needs to be calculated.

Any help much appreciated.

Since you state that:
"Only the result in column D needs to be calculated"
I'll assume that you have already entered the list of unique names in Column
C.

So, in D1 enter this:

=Sumif(A$1:A$5,C1,B$1:B$5)

And copy down.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ceab" <(E-Mail Removed)> wrote in message
news:OCIuj.312$(E-Mail Removed)...
>I want to add the sales (column B) of the people in column A.
>
> A B
> James 23
> Randy 43
> Paul 12
> James 40
> Paul 50
>
> ...and get this result:
> C D
> James 63
> Randy 43
> Paul 62
>
> Only the result in column D needs to be calculated.
>
> Any help much appreciated.
>

Thanks for the hint.
I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5)


"RagDyer" <(E-Mail Removed)> kirjoitti
viestissä:%(E-Mail Removed)...
> Since you state that:
> "Only the result in column D needs to be calculated"
> I'll assume that you have already entered the list of unique names in
> Column C.
>
> So, in D1 enter this:
>
> =Sumif(A$1:A$5,C1,B$1:B$5)
>
> And copy down.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "ceab" <(E-Mail Removed)> wrote in message
> news:OCIuj.312$(E-Mail Removed)...
>>I want to add the sales (column B) of the people in column A.
>>
>> A B
>> James 23
>> Randy 43
>> Paul 12
>> James 40
>> Paul 50
>>
>> ...and get this result:
>> C D
>> James 63
>> Randy 43
>> Paul 62
>>
>> Only the result in column D needs to be calculated.
>>
>> Any help much appreciated.
>>
>
>

You're welcome. and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"ceab" <(E-Mail Removed)> wrote in message
news:hwPuj.9$(E-Mail Removed)...
Thanks for the hint.
I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5)


"RagDyer" <(E-Mail Removed)> kirjoitti
viestissä:%(E-Mail Removed)...
> Since you state that:
> "Only the result in column D needs to be calculated"
> I'll assume that you have already entered the list of unique names in
> Column C.
>
> So, in D1 enter this:
>
> =Sumif(A$1:A$5,C1,B$1:B$5)
>
> And copy down.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "ceab" <(E-Mail Removed)> wrote in message
> news:OCIuj.312$(E-Mail Removed)...
>>I want to add the sales (column B) of the people in column A.
>>
>> A B
>> James 23
>> Randy 43
>> Paul 12
>> James 40
>> Paul 50
>>
>> ...and get this result:
>> C D
>> James 63
>> Randy 43
>> Paul 62
>>
>> Only the result in column D needs to be calculated.
>>
>> Any help much appreciated.
>>
>
>

=SUMIFS(B2:B6,A2:A6,"=J*")

Please note J* = Starting letter J

Like than u can change R* and P*



ceab wrote:

Conditional addition of cells
19-Feb-08

I want to add the sales (column B) of the people in column A

A
James 2
Randy 4
Paul 1
James 4
Paul 5

....and get this result
C
James 6
Randy 4
Paul 6

Only the result in column D needs to be calculated

Any help much appreciated.

Previous Posts In This Thread:

On Tuesday, February 19, 2008 5:20 PM
ceab wrote:

Conditional addition of cells
I want to add the sales (column B) of the people in column A

A
James 2
Randy 4
Paul 1
James 4
Paul 5

....and get this result
C
James 6
Randy 4
Paul 6

Only the result in column D needs to be calculated

Any help much appreciated.

On Tuesday, February 19, 2008 6:11 PM
RagDyer wrote:

Re: Conditional addition of cells
Since you state that
"Only the result in column D needs to be calculated
I'll assume that you have already entered the list of unique names in Column
C

So, in D1 enter this

=Sumif(A$1:A$5,C1,B$1:B$5

And copy down
--
HTH

R

--------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
--------------------------------------------------------------------------
"ceab" <(E-Mail Removed)> wrote in message
news:OCIuj.312$(E-Mail Removed)...

On Wednesday, February 20, 2008 1:11 AM
ceab wrote:

Thanks for the hint.
Thanks for the hint
I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5)

On Wednesday, February 20, 2008 9:46 AM
RagDyeR wrote:

You're welcome. and appreciate the feed-back.
You're welcome. and appreciate the feed-back
--

Regards

R
----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit
----------------------------------------------------------------------------------------------

"ceab" <(E-Mail Removed)> wrote in message
news:hwPuj.9$(E-Mail Removed)..
Thanks for the hint
I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5

"RagDyer" <(E-Mail Removed)> kirjoitt
viestiss?:%(E-Mail Removed)...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Selected Text Favorites Utility for your Web Site
http://www.eggheadcafe.com/tutorials...-text-fav.aspx

Replying to a two year old thread?

Jordon

mani kandan wrote:
> =SUMIFS(B2:B6,A2:A6,"=J*")
>
> Please note J* = Starting letter J
>
> Like than u can change R* and P*
>
>
>
> ceab wrote:
>
> Conditional addition of cells
> 19-Feb-08
>
> I want to add the sales (column B) of the people in column A.
>
> A B
> James 23
> Randy 43
> Paul 12
> James 40
> Paul 50
>
> ...and get this result:
> C D
> James 63
> Randy 43
> Paul 62
>
> Only the result in column D needs to be calculated.
>
> Any help much appreciated.
>
> Previous Posts In This Thread:
>
> On Tuesday, February 19, 2008 5:20 PM
> ceab wrote:
>
> Conditional addition of cells
> I want to add the sales (column B) of the people in column A.
>
> A B
> James 23
> Randy 43
> Paul 12
> James 40
> Paul 50
>
> ...and get this result:
> C D
> James 63
> Randy 43
> Paul 62
>
> Only the result in column D needs to be calculated.
>
> Any help much appreciated.
>
> On Tuesday, February 19, 2008 6:11 PM
> RagDyer wrote:
>
> Re: Conditional addition of cells
> Since you state that:
> "Only the result in column D needs to be calculated"
> I'll assume that you have already entered the list of unique names in Column
> C.
>
> So, in D1 enter this:
>
> =Sumif(A$1:A$5,C1,B$1:B$5)
>
> And copy down.